Challenge #10: Date Time Calculations

[Nolan]

Here is my solution! Super quick but I enjoyed figuring out the math in my formulas.

Spoiler

[Anand_Parekar]

Happy to solve the problem - The solution has been uploaded to the article.

[Anand_Parekar]

Happy to solve the WC - The solution has been uploaded to the article.

[jennifer_owens]

They you change the time now at some point? The input does not match the output but here is my solution based on the input data but will not match the minutes and seconds in the output. 

[Amilley]

I always a love a single tool solution - Leveraged some floor rounding and utilizing the preceding calculated filed to continue down the line until I got to seconds:

[Dani_Lin]

solved

[mshishido]

Here it is

[nbendoff]

Solution

[prasadmundewadi]

Spoiler

(DateTimeDiff([Time_Now],[TIMESTAMP],"sec") - Mod((DateTimeDiff([Time_Now],[TIMESTAMP],"sec")),24*60*60))/(24*60*60)

Only one formula tool

[hang_nguyen_kpmg]

Spoiler