Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

piotrzawistowski
8 - Asteroid
 
shadakht
6 - Meteoroid

Here is my take to this challenge. Used one formula tool with 4 formulas in it each for Days, Hours, Minutes and Seconds.

 

Nmetzgen1
8 - Asteroid

Solution attached

jeng
8 - Asteroid
Spoiler
Just applied the datediff function for each date component

challenge 10.png
MattBenj
9 - Comet

Solution attached. Input and output file data is different.

EricR
Moderator
Moderator
 
mertshepard
8 - Asteroid

Solution attached. Input and output are different as the comments previously have mentioned.

erutherford
6 - Meteoroid

Solution attached 🙂

 

Note that the input and output in the starting file don't quite match - that had me confused for a while!

MikeHinz
8 - Asteroid

One Tool!

DevinG
5 - Atom

My Solution!