Challenge #10: Date Time Calculations

[shadakht]

Here is my take to this challenge. Used one formula tool with 4 formulas in it each for Days, Hours, Minutes and Seconds.

[Nmetzgen1]

Solution attached

[jeng]

Spoiler

Just applied the datediff function for each date component

[MattBenj]

Solution attached. Input and output file data is different.

[mertshepard]

Solution attached. Input and output are different as the comments previously have mentioned.

[erutherford]

Solution attached 🙂

Note that the input and output in the starting file don't quite match - that had me confused for a while!

[MikeHinz]

One Tool!

[DevinG]

My Solution!