Challenge #10: Date Time Calculations

[kvnpt]

One formula tool.  Would like to learn the mod formula approach though.  It looks simpler than ensuring all the conversions are correct.

Spoiler

[ydmuley]

 Here is my 15th Solution! Doing random ones but it's always fun :)

The solving thrill continues!!!!!!!!!!!!!!!!

[Wouter]

My solution:

Spoiler

[jevon]

Spoiler

[SGriggs]

Solution is attached

[Mikkel_D_Karlsen]

Thanks for a great challenge :)

My solution

[aking]

#10 done

got a bit caught up in the difference in the 2 files! 

[tcroberts]

Here's my solution

Thanks to alex for posting about the difference in the TimeNow and Timestamp fields between the input and output data, I was wondering if I had done something wrong.

I just computed the time difference in seconds, and then used MOD() to find out how many days/hours/minutes/seconds, FLOOR()-ing where needed.

[Kenda]

Spoiler