Spreadsheet: 97596d1296733474-excel-2007-formatting-and-sum-excel-format-example
Sheet: Staff 1

 | Details of Hours Worked
 | Date | Shift 1 |  | Shift 2 |  | TOTAL BASIC | Additional Hours
 |  | Start | Finish | Start | Finish |  | Description |  | Qty | Comments
 | 1st
 | 2nd
 | 3rd | 07:00:00 | 11:00:00
 | 4th
 | 5th
 | 6th
 | 7th
 | 8th
 | 9th
 | 10th | 08:00:00 | 13:30:00
 | 11th
 | 12th
 | 13th
 | 14th
 | 15th | 08:00:00 | 09:15:00 | 13:00:00 | 16:30:00
 | 16th
 | 17th
 | 18th
 | 19th
 | 20th
 | 21st
 | 22nd
 | 23rd
 | 24th
 | 25th
 | 26th | 07:00:00 | 11:00:00
 | 27th
 | 28th
 | 29th
 | 30th | 07:45:00 | 19:15:00
 | 31st
 | Adjustments From Previous Month
 | Month | Description |  | Quantity | Add or Deduct? |  | Total | Comments
 | Staff Summary Hours
 | Description |  | Basic Hours |  | Adjustments |  | Net total
 | Basic Hours
 | Days
 | Overtime
 | Nights/Sleeps
 | Call Outs
 | Holiday
 | Bank Holiday
 | [NAME]
 | Cleaning
 | Gardening
 | Check
 | 07:00:00 | 08:00:00 | 09:00:00 | 00:30:00 | 1
 | 07:15:00 | 08:15:00 | 09:15:00 | 01:00:00 | 2 | Add | Yes
 | 07:30:00 | 08:30:00 | 09:30:00 | 01:30:00 | 3 | Deduct | No
 | 07:45:00 | 08:45:00 | 09:45:00 | 02:00:00 | 4
 | 08:00:00 | 09:00:00 | 10:00:00 | 02:30:00 | 5
 | 08:15:00 | 09:15:00 | 10:15:00 | 03:00:00 | 6
 | 08:30:00 | 09:30:00 | 10:30:00 | 03:30:00 | 7
 | 08:45:00 | 09:45:00 | 10:45:00 | 04:00:00 | 8
 | 09:00:00 | 10:00:00 | 11:00:00 | 04:30:00 | 9
 | 09:15:00 | 10:15:00 | 11:15:00 | 05:00:00 | 10
 | 09:30:00 | 10:30:00 | 11:30:00 | 05:30:00 | 11
 | 09:45:00 | 10:45:00 | 11:45:00 | 06:00:00 | 12
 | 10:00:00 | 11:00:00 | 12:00:00 | 06:30:00
 | 10:15:00 | 11:15:00 | 12:15:00 | 07:00:00
 | 10:30:00 | 11:30:00 | 12:30:00 | 07:30:00
 | 10:45:00 | 11:45:00 | 12:45:00 | 08:00:00
 | 11:00:00 | 12:00:00 | 13:00:00 | 08:30:00 | Jan | 2011
 | 11:15:00 | 12:15:00 | 13:15:00 | 09:00:00 | Feb | 2012
 | 11:30:00 | 12:30:00 | 13:30:00 | 09:30:00 | Mar | 2013
 | 11:45:00 | 12:45:00 | 13:45:00 | 10:00:00 | Apr | 2014
 | 12:00:00 | 13:00:00 | 14:00:00 | 10:30:00 | May | 2015
 | 12:15:00 | 13:15:00 | 14:15:00 | 11:00:00 | Jun | 2016
 | 12:30:00 | 13:30:00 | 14:30:00 | 11:30:00 | Jul | 2017
 | 12:45:00 | 13:45:00 | 14:45:00 | 12:00:00 | Aug | 2018
 | 13:00:00 | 14:00:00 | 15:00:00 | 12:30:00 | Sep | 2019
 | 13:15:00 | 14:15:00 | 15:15:00 | 13:00:00 | Oct | 2020
 | 13:30:00 | 14:30:00 | 15:30:00 | 13:30:00 | Nov
 | 13:45:00 | 14:45:00 | 15:45:00 | 14:00:00 | Dec
 | 14:00:00 | 15:00:00 | 16:00:00 | 14:30:00
 | 14:15:00 | 15:15:00 | 16:15:00 | 15:00:00
 | 14:30:00 | 15:30:00 | 16:30:00 | 15:30:00
 | 14:45:00 | 15:45:00 | 16:45:00 | 16:00:00
 | 15:00:00 | 16:00:00 | 17:00:00 | 16:30:00
 |  | 16:15:00 | 17:15:00 | 17:00:00
 |  | 16:30:00 | 17:30:00 | 17:30:00
 |  | 16:45:00 | 17:45:00 | 18:00:00
 |  | 17:00:00 | 18:00:00 | 18:30:00
 |  | 17:15:00 | 18:15:00 | 19:00:00
 |  | 17:30:00 | 18:30:00 | 19:30:00
 |  | 17:45:00 | 18:45:00 | 20:00:00
 |  | 18:00:00 | 19:00:00 | 20:30:00
 |  | 18:15:00 | 19:15:00 | 21:00:00
 |  | 18:30:00 | 19:30:00 | 21:30:00
 |  | 18:45:00 | 19:45:00 | 22:00:00
 |  | 19:00:00 | 20:00:00 | 22:30:00
 |  | 19:15:00 | 20:15:00 | 23:00:00
 |  | 19:30:00 | 20:30:00
 |  | 19:45:00 | 20:45:00
 |  | 20:00:00 | 21:00:00