Spreadsheet: 188247d1350766771-difficulty-adding-up-hours-worked-within-a-spreadsheet-hours-and-holidays-calculator
Sheet: Hours and Holidays

 | Monday | Start | Finish | Total | Tuesday | Start | Finish | Total | Wednesday | Start | Finish | Total | Thursday | Start | Finish | Total | Friday | Start | Finish | Total
A.M | [NAME] | 07:30:00 | 09:00:00 | 01:30:00 | [NAME] | 07:30:00 | 09:00:00 | 01:30:00 | [NAME] | 07:30:00 | 09:00:00 | 01:30:00 | [NAME] | 07:30:00 | 09:00:00 | 01:30:00 | [NAME] | 07:30:00 | 09:00:00 | 01:30:00
 | Gemma | 07:30:00 | 09:00:00 | 01:30:00 | Gemma | 07:30:00 | 09:00:00 | 01:30:00 | [NAME] | 07:45:00 | 09:00:00 | 01:15:00 | [NAME] | 07:45:00 | 09:00:00 | 01:15:00 | [NAME] | 07:45:00 | 09:00:00 | 01:15:00
 | Victoria | 07:45:00 | 09:00:00 | 01:15:00 | [NAME] | 07:45:00 | 09:00:00 | 01:15:00 | [NAME] | 07:45:00 | 09:00:00 | 01:15:00 | [NAME] | 07:45:00 | 09:00:00 | 01:15:00 | [NAME] | 07:45:00 | 09:00:00 | 01:15:00
 | Valentina | 07:45:00 | 09:00:00 | 01:15:00 | Victoria | 08:00:00 | 09:00:00 | 01:00:00 | Valentina | 08:00:00 | 09:00:00 | 01:00:00 | [NAME] | 08:00:00 | 09:00:00 | 01:00:00 | Victoria | 08:00:00 | 09:00:00 | 01:00:00
 |  |  |  |  |  |  |  |  | Victoria | 08:00:00 | 09:00:00 | 01:00:00 | Kelly | 08:00:00 | 09:00:00 | 01:00:00 | Valentina | 08:00:00 | 09:00:00 | 01:00:00
P.M | [NAME] | 15:15:00 | 18:00:00 | 02:45:00 | [NAME] | 15:15:00 | 18:00:00 | 02:45:00 | [NAME] | 15:15:00 | 18:00:00 | 02:45:00 | [NAME] | 15:15:00 | 18:00:00 | 02:45:00 | [NAME] | 15:15:00 | 18:00:00 | 02:45:00
 | Gemma | 15:00:00 | 18:00:00 | 03:00:00 | Gemma | 15:00:00 | 18:00:00 | 03:00:00 | [NAME] | 15:00:00 | 18:00:00 | 03:00:00 | [NAME] | 15:00:00 | 18:00:00 | 03:00:00 | [NAME] | 15:00:00 | 18:00:00 | 03:00:00
 | [NAME] | 15:00:00 | 18:00:00 | 03:00:00 | [NAME] | 15:00:00 | 18:00:00 | 03:00:00 | [NAME] | 15:00:00 | 18:00:00 | 03:00:00 | Victoria | 15:00:00 | 18:00:00 | 03:00:00 | Victoria | 15:00:00 | 18:00:00 | 03:00:00
 | Kelly | 15:00:00 | 18:00:00 | 03:00:00 | Kelly | 15:00:00 | 18:00:00 | 03:00:00 | [NAME] | 15:00:00 | 18:00:00 | 03:00:00 | Kelly | 15:00:00 | 18:00:00 | 03:00:00 | Kelly | 15:00:00 | 18:00:00 | 03:00:00
 | Victoria | 15:00:00 | 18:00:00 | 03:00:00 | [NAME] | 15:00:00 | 18:00:00 | 03:00:00 | Rebecca | 15:45:00 | 17:45:00 | 02:00:00 | Valentina | 15:00:00 | 18:00:00 | 03:00:00
 | Valentina | 15:00:00 | 17:00:00 | 02:00:00 | Victoria | 15:00:00 | 18:00:00 | 03:00:00 |  |  |  |  | [NAME] | 15:00:00 | 18:00:00 | 03:00:00
 | Total Hours |  | No for calc | Leave | R/U | % for calc | BH | BH | Holidays | Leave | BH
 | [NAME] | 21:15:00 | 21.15 | 118.44 | 119 | 57.16216216216215 | 32.01081081081081 | 33 | [NAME] | 119 | 33
 | Gemma | 09:00:00 | 9 | 50.4 | 51 | 24.32432432432433 | 13.62162162162162 | 14 | Gemma | 51 | 14
 | Victoria | 16:15:00 | 16.15 | 90.43999999999998 | 91 | 43.64864864864865 | 24.44324324324324 | 25 | Victoria | 91 | 25
 | Valentina | 08:15:00 | 8.15 | 45.64 | 46 | 22.02702702702703 | 12.33513513513514 | 13 | [NAME] | 46 | 13
 | [NAME] | 11:15:00 | 11.15 | 62.44 | 63 | 30.13513513513514 | 16.87567567567568 | 17 | [NAME] | 63 | 17
 | [NAME] | 09:45:00 | 9.45 | 52.91999999999999 | 53 | 25.54054054054054 | 14.3027027027027 | 15 | [NAME] | 53 | 15
 | Kelly | 13:00:00 | 13 | 72.8 | 73 | 35.13513513513514 | 19.67567567567568 | 20 | Kelly | 73 | 20
 | [NAME] | 15:45:00 | 15.45 | 86.52 | 87 | 41.75675675675675 | 23.38378378378378 | 24 | [NAME] | 87 | 24
 | Rebecca | 02:00:00 | 2 | 11.2 | 12 | 5.405405405405405 | 3.027027027027027 | 4 | Rebecca | 12 | 4