Hi, I have an IFTTT function which is recording dates and times I enter an area to track hours worked on a google doc. The issue i have is that it logs a sentence, not allowing me to work with the data. Is there a way that a formula or formulas can re-work the data to give me the hours worked per day?

If not this, then at least a way to split out the dates and convert the times to 24 hour clock? Happy to copy the data to excel to get the results.

Data appears like this in 2 columns (date & time in column b)

Arrived at work April 8, 2019 at 08:35AM
Left work April 8, 2019 at 01:18PM
Arrived at work April 8, 2019 at 01:55PM
Left work April 8, 2019 at 06:18PM
Arrived at work April 9, 2019 at 08:42AM
Left work April 9, 2019 at 06:43PM
Arrived at work April 10, 2019 at 08:47AM
Left work April 10, 2019 at 12:49PM
Arrived at work April 10, 2019 at 03:44PM
Left work April 10, 2019 at 06:59PM

Thanks,
Jenny