Hello
I have a work rota, and would like to calculate the hours worked from a single cell.
e.g.
CELL A2 Employee 1
CELL B1 Monday
CELL B2 10am-2.30pm.
I would expect the above example to return 4.5 in a cell called Hours
I would then like all the days to be added to give a weekly total per employee.
Most solutions I have seen online have a check in/out procedure, but since I want to print the rota and not have it look like a series of numbers, I was hoping for a more pleasing solution.
Thanks!