Challenge #10: Date Time Calculations

[Maskell_Rascal]

Love a good DateTime challenge! Solved this one with one tool! 😀

To other challengers, the Time_Now value in the Output is different than the one in the Input, so your results will not match. 

Spoiler

Days = DateTimeDiff([Time_Now],[TIMESTAMP],'days')
Hours = DateTimeDiff([Time_Now],[TIMESTAMP],'hours')-[Days]*24
Minutes = DateTimeDiff([Time_Now],[TIMESTAMP],'minutes')-([Days]*1440)-([Hours]*60)
Seconds = DateTimeDiff([Time_Now],[TIMESTAMP],'seconds')-([Days]*86400)-([Hours]*3600)-([Minutes]*60)

Cheers!

Phil

[RashedDS]

My solution 

[GSD]

My solution to the challenge:

Spoiler

 

[ABAsseged]

Spoiler

[ENix]

Spoiler

[SWalker]

Spoiler

 

[TKSnider]

My solution is below

Honestly, this wasn't so much an intermediate, but closer to a beginner level (IMO).  Very limited need for much in the tool palette.

[Vishnu_Sekhar]

Using the Mod function did the trick. Please find the attachment for the solution, 

[ARussell34]

Here is my solution!

[Mario36]

Here's my solution. This is a beginner challenge, I would not agree for this to be an intermediate.

Spoiler

Use the Formula Tool effectively with DataTimeDiff