Want to get involved? We're always looking for ideas and content for Weekly Challenges.
Here is my solution! Super quick but I enjoyed figuring out the math in my formulas.
Happy to solve the problem - The solution has been uploaded to the article.
Happy to solve the WC - The solution has been uploaded to the article.
They you change the time now at some point? The input does not match the output but here is my solution based on the input data but will not match the minutes and seconds in the output.
I always a love a single tool solution - Leveraged some floor rounding and utilizing the preceding calculated filed to continue down the line until I got to seconds:
Here it is
Only one formula tool