Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAOne formula tool. Would like to learn the mod formula approach though. It looks simpler than ensuring all the conversions are correct.
Here is my 15th Solution! Doing random ones but it's always fun :)
The solving thrill continues!!!!!!!!!!!!!!!!
My solution:
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.