Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAIt 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
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
My answer is same till hour but i haven't done nothing wrong in my point of view 🤔