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

Dazzerman
Bolide

Did 2 solutions for this one.

 

Révélation
Used long calculations in the first solution, and MOD calculations in the second.

Challenge10.jpg
mat_budden
Astéroïde

Hi All,

 

Please find below my Results

 

Révélation
For this one i just brut forced it with a Repeating Formula..... Probably not ideal.... But does make the Workflow Page nice and Neat......

Thanks

Mat

RoDO
Astéroïde

My solution

 

Révélation
challenge_10_RODO_Solution.png
palakjindal
Météoroïde

Attaching my solution

ZenonH
Astéroïde

Like the question mentioned, slight difference in time.

Révélation
ZHSOL.png
justindavis
Boule de feu

Would be a good macro to create and use now and again

Révélation
challenge_10_solution_justindavis.PNG
kmcdaniel
Astéroïde

Only needed a single tool!

 

Révélation
screensho10.png
KT2
Météore
Révélation
 

Boom.

Sebenius
Astéroïde

Time parsing allways good to keep track of

Révélation
challenge_10_Done_img.png

SueDonim
Astéroïde

Off by 41 seconds given the time change, but otherwise seems there

 

 

Révélation
I like the modulo idea that @mceleavey did.  I think I'll redo it to give that a go.  More elegant than the brute force subtractions I did

MySolution.PNG