Challenge #10: Date Time Calculations
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
NatSnook
8 - Asteroid
02-22-2024
05:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
rmorrguitar
7 - Meteor
02-23-2024
08:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
katiematkin93
8 - Asteroid
02-24-2024
05:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Oniel182
7 - Meteor
02-26-2024
08:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
JWAJ
7 - Meteor
02-27-2024
06:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It too me a while to realize that the input and output "time now" was not identical. this is my solution i did not know about the MOD function why i did it this way
DWingelaar
6 - Meteoroid
02-29-2024
03:08 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Spoiler
Used both the rougher
Hours: DateTimeDiff([Time_Now],[TIMESTAMP],'Hours')-[Days]*24
Minutes: DateTimeDiff([Time_Now],[TIMESTAMP],'Minutes')-([Days]*24+[Hours])*60
And the cleaner
DateTimeDiff([Time_Now],[TIMESTAMP],'Seconds')-DateTimeDiff([Time_Now],[TIMESTAMP],'Minutes')*60
pmag
8 - Asteroid
02-29-2024
04:19 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Volha
8 - Asteroid
03-04-2024
07:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
JakubJ
8 - Asteroid
03-05-2024
04:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Dev73
8 - Asteroid
03-08-2024
07:11 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
My answer is same till hour but i haven't done nothing wrong in my point of view 🤔