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

Tisaac95
8 - Asteroid
Spoiler
 
JonathanW
8 - Asteroid

My solution is just a formula tool so I won't post screenshot

Original_Yodies
8 - Asteroid
Spoiler
Original_Yodies_1-1578369108444.png Original_Yodies_2-1578369156394.png

 good date formulas challenge.

andypick
8 - Asteroid

solution attached

 

Spoiler
Capture.PNG
mdodrajka
8 - Asteroid

Very interesting requirement.

 

Spoiler
Initially solved it with just using Nested DateTimeDiff. Then got inspired by the Floor function used by Sean so did it the arithmetic way.

Challenge_10_Mdodrajka.PNG

ShawnTM
8 - Asteroid

Hi, here's my solution. My values for seconds differ slightly from the example output, but i think it's due to the fact that the inputs also differ slightly.

Spoiler
ShawnTM_0-1578678278778.png
jad0575
6 - Meteoroid
Spoiler
I did it with a lot of equations because I forget about the MOD. good one.
terry10
12 - Quasar

 

 

dashakir1
8 - Asteroid

Thanks GeneR.

justinjohnson02
7 - Meteor
Spoiler
justinjohnson02_0-1579404470568.png