community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #10: Date Time Calculations

 
Atom

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

 

Asteroid

Solution attached

Meteor
Spoiler
Just applied the datediff function for each date component

challenge 10.png
Asteroid

Solution attached. Input and output file data is different.

Moderator
Moderator
 
Meteoroid

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

Highlighted
Meteoroid

Solution attached

 

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

Asteroid

One Tool!

Atom

My Solution!