Free Trial

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #10: Date Time Calculations

jacelu
6 - Meteoroid

My one formula tool take.

 

Spoiler
Only 2 functions were needed, one was the mod function and the other is the DateTimeDiff function. Combining the 2 function gives you the difference in the hours, minutes and seconds. But make sure you give the right mod, I gave the mod for hours a 24 because we only have 24 hours in a day, mod for minutes of a 60 because you only have 60 minutes in an hour, and a mod of 60 for seconds because theres only 60 seconds in a minute. 
Spoiler
excercise 10.PNGexcercise 10 part 2.PNG
Jfoss
6 - Meteoroid

A real head scratcher when the output has different timestamps. Did not know about the MOD() formula and will be using that in the future. 

Dominic_Brady
7 - Meteor

Great to get some practice with the MOD() and FLOOR() functions