Challenge #10: Date Time Calculations

[SamBreen]

Maybe not the most elegant solution, but a solution nonetheless. I kept the formula tools separate for visual purposes

Spoiler

Spoiler

 

[Gmajid786]

My Solution and formulas used:

DateTimeDiff([Time_Now],[TIMESTAMP],"days")

DateTimeDiff([Time_Now],[TIMESTAMP],"hours")-[Days]*24

DateTimeDiff([Time_Now],[TIMESTAMP],"minutes")-DateTimeDiff([Time_Now],[TIMESTAMP],"hours")*60

DateTimeDiff([Time_Now],[TIMESTAMP],"seconds")-DateTimeDiff([Time_Now],[TIMESTAMP],"minutes")*60

[toby49]

Spoiler

My solution

[sherinamahtani]

Check out my solution

[cnlarsen]

Here is my solution.

[StellaBon]

Spoiler

[Pilsner]

My Solution:

Spoiler

 

[nikhilnijhar]

Spoiler

[danielhoge]

Spoiler

[AndreeaS]

Spoiler