Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAWhen my results didn't match the expected output I of course thought I did something wrong. No, the expected output was created 41 seconds after the input. The easy fix was to add 41 seconds to my formala, LOL.
One tool.
Used 7 formulas within the Formula tool, and excluded the unnecessary columns with Select tool. Used original input file, so times are a little off.
All,
My submission is attached.
-I used the Time Difference Function which calculates intervals in Days/Hours/Minutes/Seconds and the Mod function which calculates the remainder in order to calculate the remainder the remaining hours, minutes, seconds, etc.
-Cheers!
Matt
Here's my solution