Challenge #10: Date Time Calculations

[MarMu]

Good ol' 1 tool wunder. A round of applause for MOD

Had to use the solution file as input as DataTime_Now in input is 41 seconds earlier than output

Spoiler

[tammybrown_tds]

I used modulo formulas for the minutes, hours and seconds.

[pmwillen]

Spoiler

A little more manual than I would have preferred, but it works.

[myastarling]

Here's my solution.

[kat]

Spoiler

[willstom1]

Here is my solution - rather than using floor or mod I changed data type to fixed decimal to truncate the result of the calculation:

Spoiler

[AT_12]

Step 1: Used DateTime Tool

Step 2: Formula Tool

DateTimeDiff= DateTimeDiff([DateTimeNOW],[DateTime],"seconds")

Days= DateTimeDiff([Time_Now],[TIMESTAMP],"days")

Hours= DateTimeDiff([Time_Now],[TIMESTAMP],"hours")-DateTimeDiff([Time_Now],[TIMESTAMP],"days")*24

Minutes: DateTimeDiff([Time_Now],[TIMESTAMP],"minutes")

-(DateTimeDiff([Time_Now],[TIMESTAMP],"hours")*60)

Seconds= DateTimeDiff([Time_Now],[TIMESTAMP],"seconds")

-(DateTimeDiff([Time_Now],[TIMESTAMP],"minutes")*60)

[TimothyB]

My attempt - Multi Row formula to update Time Now Column (for accuracy). Four Column Formula using TimeDateDiff and subtracting the formula value at the appropriate conversion scale. 

Spoiler

Updated with Formula configuration screenshot

[MattDuncan]

Solution attached :)

[OllieClarke]

Just the one tool this week:

Spoiler