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

スポイラ

[tammybrown_tds]

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

[pmwillen]

スポイラ

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

[myastarling]

Here's my solution.

[kat]

スポイラ

[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:

スポイラ

[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. 

スポイラ

Updated with Formula configuration screenshot

[MattDuncan]

Solution attached :)

[OllieClarke]

Just the one tool this week:

スポイラ