Start 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

Archie_bos
8 - Asteroid

Please make it a little more clear that the answer will be different to the output !!!

BS_THE_ANALYST
15 - Aurora
15 - Aurora

Only 1 tool used to obtain the answer, but don't be fooled. I did a long-winded approach for the solution but the iterations were fun!

Spoiler
BS_THE_ANALYST_0-1672186615505.png

 

All the best,
BS

LinkedIN

Bulien
Spurs
8 - Asteroid
Spoiler
Spurs_0-1672224617969.png

Definitely didn't need so many steps but hey ho.

BS_THE_ANALYST
15 - Aurora
15 - Aurora

After giving my previous solution, using nested time addition (felt forced), I saw @mceleavey's solution using the mod function. His was more elegant, and great use of the mod function! Great challenge, lots learned. 

 

Spoiler
BS_THE_ANALYST_0-1672226213894.png

 

 

 

All the best,
BS

LinkedIN

Bulien
KathrynMW
8 - Asteroid

Did several formulae in one formula tool... no doubt there is a far more efficient way to do this so I'll go back and look at some of the other solutions soon.

Spoiler
Challenge 10 Spoiler.JPG

kaiserj
8 - Asteroid

solved

Minsu
7 - Meteor

Here is my solution!

ydevis
8 - Asteroid
Spoiler
ydevis_0-1672394052741.png

 

isabelcc
8 - Asteroid
Spoiler
10.png

duonglindaa
7 - Meteor
Spoiler
duonglindaa_0-1673340733318.png