Convert populated timesheet into hours worked

[jenmc84]

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

[José Augusto]

Hi

I assume your data is in column A, just like your post shows.

I define the name Months as ={"January";"February";"March";"April";"May";"June";"July";"August";"September";"October";"November";"December"}

Columns B, C, D, E are (Year, Month, Day, Time) determined by the following formulas

Please Login or Register  to view this content.

The date-time can be achieved using

Please Login or Register  to view this content.

Now you can operate with real data-time as I do in column G, in G2 with =F3-F2 and leave G3 empty.
To drag down the formula you must select G2:G3.

See the file for clarification