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

Tomasch
7 - Meteor

done

amanda_payne
8 - Asteroid

I added the seconds back before the rest

Spoiler
amanda_payne_1-1625684600414.png

 

Elias_Nordlinder
11 - Bolide

Here is my solution (2 solutions),

One long because I did  not get the first one to work first, and one shorter 🙂

 

Spoiler
Elias_Nordlinder_0-1626115419798.png

 

cwkoops
8 - Asteroid

My solution:

DanTh
Alteryx
Alteryx
Spoiler
Fairly simple once I found the right Formula expression for Modulo.

5/5
KyronSmith
7 - Meteor

I found this one tricky, had to take a quick look at the solution... I better work on Formulas and RegEx's!

JoaoLeiteV
10 - Fireball

This was a quick one haha, just used a Formula to create and calculate the differences.

 

Spoiler
JoaoLeiteV_0-1626894557338.png

 

pdave87
11 - Bolide

Hi Alex,

 

That's very helpful and easy to understand. Thanks alot. 

 

Regards,

Pratik

pdave87
11 - Bolide

PFA my solution. There are multiple ways and they are quite simple. It's very good learning

rahulchetwani
5 - Atom

I have used the date calculation formula but in the first line of solution, mm/sec difference was 17 min 29 sec and mine is 16 min and 48 sec .Please let me know if you figured out my mistake.