Challenge #10: Date Time Calculations

[mithily]

Spoiler

Spoiler

spoiler  I used the ouputs datetimeout values to match the numbers exactly

[Aske_T]

Solution - Difference in the time stamps tho. :) 

[CVCurcurato]

Was so confused for a while because I didn't realize the input timestamps were off by 41 seconds! One formula tool solution.

 

[MatteoReddavide]

My solution

Spoiler

[lwolfie]

My solution

[MartinStraech]

My solution. Modulus is a very useful math function.

Spoiler

[H_a_n_g_C_h_e_n__x3]

It is honestly a fun one 

[josedlr00]

I spent a long time figuring out the answer to this challenge. It was a good challenge in which I learned more about the date formulas. I definitely need more practice.

[jstewa13]

went quick, maybe not the cleanest math but it works

[Krzysztof_Hyla_1986]

My solution. Actually 2 alternative solutions :-)

Spoiler

Days = DateTimeDiff([Time_Now],[TIMESTAMP],'day')
Hours = Mod( DateTimeDiff([Time_Now],[TIMESTAMP],'hours') , 24)
Minutes = Mod( DateTimeDiff([Time_Now],[TIMESTAMP],'minutes'), 60)
Seconds = Mod( DateTimeDiff([Time_Now],[TIMESTAMP],'seconds'), 60)