How to calculate hours worked between two text shifts

1

Hi,
I'm having trouble calculating hours worked in decimal format between two Time in/time out values that are in text format. Values such as 09:00 for time in and 17:00 for time out. When trying to create a formula to calculate the difference, I'm getting errors due it being text format and have been unsuccessful converting it to number. I would also like to convert the hours worked to decimal so that 15 minutes would be 0.25.

See the attached spreadsheet for an example import. 00:00 shifts are midnight.

Timesheet Import.xlsx (137.3 KB)

2

Calculate hours.morph (4.7 KB)

Here is an example of how to calculate hours.

Kind regards,

Jochen

1 Like