Challenge #10: Date Time Calculations

[emily_cummings]

solution:

[Rob-Silk]

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

Spoiler

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]

Spoiler

[putu_w_erata]

Spoiler

 

[caitlynmcintyre]

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

Spoiler

[phillipcjang]

Spoiler

 

[Rohit_Pokhriyal]

Thank you!

[Tonio6789]

Challenge #10: Date Time Calculations

[nikhil_jaju]

Solution

[SanjeevDosanjh]

Spoiler