How to format this question into date and time

Question

Students ran a race consisting of two laps around an outdoor cross-country obstacle course. The following dataset shows their start time, the time their first lap was finished, and the time when their second lap was finished. how many students lap faster than the first. Computed calculation in seconds not minutes?

a 13b 14c 15d 16I followed the DateTime parse to convert into datatype format, but it shows null. Any suggestion on how can I differentiate the date/time into two different columns or change the format?

Core - Lap Times.xlsx

kajoljoshi · Answer

Hi thank you for providing the workflow, I have attached my work but output doesn't come same as your. Can you please see what is missing?

New Workflow1 (1).yxmd

Yoshiro_Fujimori · Answer

@kajoljoshi ,

I hope my workflow may help.

Formulas:

Sec_Start_to_1stLap = DateTimeDiff([Time After First Lap],[Start Time],"seconds")

Sec_1stLap_to_2ndLap = DateTimeDiff([Time After Second Lap],[Time After First Lap],"seconds")

Outcome =

IF [Sec_Start_to_1stLap] > [Sec_1stLap_to_2ndLap]
THEN "2nd lap is faster"
ELSE "1st lap is faster (or same)"
ENDIF

Workflow:

Output:

So I would say the answer is "A 13"😀

DatetimeTooSeconds_yf.yxmd