Hi
I have a spreadsheet which records hours worked and produces a running total of whether this is up or down on contracted hours (37.5 hours a week). The working day is 7 hours 30 minutes.
This total is expressed in hours:minutes (see below). I am trying to get a formula which will show this has days in one cell, hours in the next and minutes in a third. I've tried many of the solutions listed on here (and elsewhere), without success.
In the table below, 66:10 should be converted into 8 days 6 hours 10 minutes.
<colgroup><col><col span="7"><col><col></colgroup><tbody>
</tbody>
I have a spreadsheet which records hours worked and produces a running total of whether this is up or down on contracted hours (37.5 hours a week). The working day is 7 hours 30 minutes.
This total is expressed in hours:minutes (see below). I am trying to get a formula which will show this has days in one cell, hours in the next and minutes in a third. I've tried many of the solutions listed on here (and elsewhere), without success.
In the table below, 66:10 should be converted into 8 days 6 hours 10 minutes.
Actual No of hours worked during week | Hours required by contract | Balance of time, +/- | Running total of overtime | ||||||
60:45:00 | |||||||||
Monday | Tuesday | Wednesday | Thursday | Friday | |||||
27-Nov-17 | 28-Nov-17 | 29-Nov-17 | 30-Nov-17 | 1-Dec-17 | |||||
Start | 7:15 | 7:15 | 7:15 | 7:10 | 7:25 | ||||
Lunch start | 12:00 | 12:00 | 12:45 | 12:00 | 12:00 | ||||
Lunch stop | 12:15 | 12:15 | 13:00 | 12:15 | 12:15 | ||||
Finish | 16:00 | 16:00 | 16:30 | 16:00 | 16:00 | ||||
Time Off | Actual | Contract | Balance | Total | |||||
Total | 8:30 | 8:30 | 9:00 | 8:35 | 8:20 | 42:55:00 | 37:30:00 | 5:25:00 | 66:10 |
<colgroup><col><col span="7"><col><col></colgroup><tbody>
</tbody>