Challenge #10: Date Time Calculations

[emily_cummings]

solution:

[Rob-Silk]

My solution below (two similar ways, but the seconds feels more elegant):

スポイラ

Both solutions use the DateTimeDiff() function, but the first uses the difference in seconds then works backwards from the number of days to the number of seconds, thereby requiring increasingly long formulae for each subsequent field, where as the second solution uses the difference in days, hours, minutes, seconds and applies the Mod() function to get the remainder for hours-to-seconds fields

[B_SarkadiNagy]

スポイラ

[putu_w_erata]

スポイラ

 

[caitlynmcintyre]

I added 41 seconds to my input so that i could validate it matched the output :)

スポイラ

[phillipcjang]

スポイラ

 

[Rohit_Pokhriyal]

Thank you!

[Tonio6789]

Challenge #10: Date Time Calculations

[nikhil_jaju]

Solution

[SanjeevDosanjh]

スポイラ