Challenge #10: Date Time Calculations

[BrandonB]

My solution:

Spoiler

 

[carmenrapariz]

Spoiler

[beccat]

My solution with the promised 41 second difference....realize I could format the formulas a little different/cleaner, but shows how it's getting each value.

[OnionKnight]

My solution!!

[rajenderk18]

Here is my solution:

Spoiler

[clmc9601]

My solution

[CatB]

Solution here - probably a few more formulas than required 

[TraceyD]

On the starter, the two input data tools have slightly different data.  If you hook up your solution to the one on the right, then use a select to remove the answer fields, you can match the answer fields with your own solution.

[MilindGadhia]

Solution attached

[NMangera]

Opted for the mod function over the more intuitive nesting route in the end, based on performance considerations over larger data sets.

Spoiler