Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAThis 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.
Solved!
First formula is just to add 41 seconds to Time_Now for checking purposes vs the output
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