Challenge #10: Date Time Calculations

[dvsrtns]

Seems like my 'Input' and 'Output' files are not the same in terms of the times used for the calculation. But I checked my solution with the 'Output' file also and got the correct answer. I'm sure I'm not the only one who commented on this, however I have not read any of the other comments myself.

Spoiler

[DataHabanero]

Missed the fact that times would vary slightly. I still ran two possible solutions which I believe are simple enough. Great challenge!

[JWS]

“You can have it all. Just not all at once.”

[rachelgatto]

Solved - as previously noted by other users the times are 41 seconds off the output file since the Time_Now stamp is different between the input file and the output file. 

[FredySantana]

Solution Posted

[nickjastrzebski]

I managed to achieve this this just one tool, though of course needed more than one formula!

Spoiler

[DiegoParker]

A few discrepancies with the solution but double checked the numbers and I believe they are correct.