Challenge #10: Date Time Calculations

[shahryal]

Spoiler

Spoiler 

[abhi__98]

here is my solution

[aazimh]

Spoiler

Decided to add 41 seconds to the Time_Now to be consistent with the output file. 

[ecarter-93]

Complete!

Spoiler

[Adam_Dooley]

 A bit frustrating to add 41 seconds to make it work, but still neat to do it all within one Formula tool.

Spoiler

DateTimeDiff(DateTimeAdd([Time_Now],41,'seconds'),[TIMESTAMP],'days')
DateTimeDiff(DateTimeAdd([Time_Now],41,'seconds'),[TIMESTAMP],'hours')-(ToNumber([Days])*24)
DateTimeDiff(DateTimeAdd([Time_Now],41,'seconds'),[TIMESTAMP],'minutes')-DateTimeDiff([Time_Now],[TIMESTAMP],'hours')*60
DateTimeDiff(DateTimeAdd([Time_Now],41,'seconds'),[TIMESTAMP],'seconds')-DateTimeDiff(DateTimeAdd([Time_Now],41,'seconds'),[TIMESTAMP],'minutes')*60

[JennyMartin]

Spoiler

Nice for practising with the datetimediff function.

[Yoyo_Master]

One tool ezpz 🙂

[kylemhabe]

My solution using one formula tool.

Spoiler

DateTimeDiff([Time_Now],[TIMESTAMP],"days")
DateTimeDiff([Time_Now],[TIMESTAMP],"hours")-([Days]*24)
DateTimeDiff([Time_Now],[TIMESTAMP],"minutes")-DateTimeDiff([Time_Now],[TIMESTAMP],"hours")*60
DateTimeDiff([Time_Now],[TIMESTAMP],"seconds")-DateTimeDiff([Time_Now],[TIMESTAMP],"minutes")*60

[jusdespommes]

Knew I had to use it but still had to go through the forums to see the utilisation of the modulo function! Thank you 🙂

Spoiler

[timrains]

Started overcomplicated but stripped back. 

Spoiler