Challenge #10: Date Time Calculations

[jacelu]

My one formula tool take.

Spoiler

Only 2 functions were needed, one was the mod function and the other is the DateTimeDiff function. Combining the 2 function gives you the difference in the hours, minutes and seconds. But make sure you give the right mod, I gave the mod for hours a 24 because we only have 24 hours in a day, mod for minutes of a 60 because you only have 60 minutes in an hour, and a mod of 60 for seconds because theres only 60 seconds in a minute. 

Spoiler

[Jfoss]

A real head scratcher when the output has different timestamps. Did not know about the MOD() formula and will be using that in the future. 

[Dominic_Brady]

Great to get some practice with the MOD() and FLOOR() functions

[JBevan89]

My Solution attached.  It took me a while to realise the output solution was not correct - apparently it's off by 41 seconds

[Dracen-Twite]

Big formula tool fan

[AK_ananthakrishnan]

Hi guys found this a good way to brush up DateTime expression skills

[TGreen]

Challenge solved.

[s_wright]

Solved challenge_10 attached.

[jand]

my solution, same as for others, some seconds are off comparing to example result :)

[RebekaMazuchova]

:)