Challenge #10: Date Time Calculations

[NathalieHP]

One tool ! 

[DenisZ]

Here is my solution

Spoiler

[KorkuSep]

This week's challenge was really an eye opener, as the task gets you thinking on why time now feature does not equal those on the input records. I learned a valuable lesson to pay attention to details when data is given, to peruse it and do some data cleaning or feature engineering.

Spoiler

[PeterHajnal]

My solution

[Ross_Easton]

Solved!

First formula is just to add 41 seconds to Time_Now for checking purposes vs the output

Spoiler

 

[AaronSmatta]

Solution

[IgnacioVilaplana]

There is a time difference between the "Time_Now" field in the input and the output, so the first tool must be an "Add 41 seconds" to that field in the input data.

 

After that, you can create the rest of the formulas to calculate the required fields.

[TimN]

Hi,

Here is my solution.

[alexhenson]

Spoiler

The timestamps were different between the input and output boxes; I copied and pasted the formula tool to the output data to confirm my formula

[trevor_harvey]

Spoiler