Spreadsheet: 763406d1642158530-linking-excel-sheets-time-sheet-ceredigion-master
Sheet: shifts

 |  |  |  | Week |  | Sat |  | Sun
 |  | Time | Hours | LowUS | HighUS | LowUS | HighUS | LowUS | HighUS
 | 1 | 0545-1515 | 9.5 | 0.25 |  | 9.5 |  |  | 9.5 |  | 0.25
 | 2 | 0600-1400 | 7.5 |  |  | 7.5 |  |  | 7.5
 | 3 | 0600-1700 | 10.5 |  |  | 10.5 |  |  | 10.5
 | 4 | 0600-1800 | 11.5 |  |  | 11.5 |  |  | 11.5
 | 5 | 0630-1630 | 9.5 |  |  | 9.5 |  |  | 9.5
 | 6 | 0630-1830 | 11.5 |  |  | 11.5 |  |  | 11.5
 | 7 | 0700-1700 | 9.5 |  |  | 9.5 |  |  | 9.5
 | 8 | 0700-1800 | 10.5 |  |  | 10.5 |  |  | 10.5
 | 9 | 0700-1900 | 11.5 |  |  | 11.5 |  |  | 11.5
 | 10 | 0730-1930 | 11.5 |  |  | 11.5 |  |  | 11.5
 | 11 | 0800-1600 | 7.5 |  |  | 7.5 |  |  | 7.5
 | 12 | 0800-1615 | 7.75 |  |  | 7.75 |  |  | 7.75
 | 13 | 0800-1700 | 8.5 |  |  | 8.5 |  |  | 8.5
 | 14 | 0800-1730 | 9 |  |  | 9 |  |  | 9
 | 15 | 0800-1745 | 9.25 |  |  | 9.25 |  |  | 9.25
 | 16 | 0800-1800 | 9.5 |  |  | 9.5 |  |  | 9.5
 | 17 | 0800-1830 | 10 |  |  | 10 |  |  | 10
 | 18 | 0800-1845 | 10.25 |  |  | 10.25 |  |  | 10.25
 | 19 | 0800-1900 | 10.5 |  |  | 10.5 |  |  | 10.5
 | 20 | 0800-1915 | 10.75 |  |  | 10.75 |  |  | 10.75
 | 21 | 0800-2000 | 11.5 |  |  | 11.5 |  |  | 11.5
 | 22 | 0810-1740 | 9 |  |  | 9 |  |  | 9
 | 23 | 0810-1800 | 9.33 |  |  | 9.33 |  |  | 9.33
 | 24 | 0810-1810 | 9.5 |  |  | 9.5 |  |  | 9.5
 | 25 | 0815-1745 | 9 |  |  | 9 |  |  | 9
 | 26 | 0815-1815 | 9.5 |  |  | 9.5 |  |  | 9.5
 | 27 | 0830-1630 | 7.5 |  |  | 7.5 |  |  | 7.5
 | 28 | 0830-1830 | 9.5 |  |  | 9.5 |  |  | 9.5
 | 29 | 0830-1930 | 10.5 |  |  | 10.5 |  |  | 10.5
 | 30 | 0845-2000 | 10.75 |  |  | 10.75 |  |  | 10.75
 | 31 | 0900-1700 | 7.5 |  |  | 7.5 |  |  | 7.5
 | 32 | 0900-1730 | 8 |  |  | 8 |  |  | 8
 | 33 | 0900-1800 | 8.5 |  |  | 8.5 |  |  | 8.5
 | 34 | 0900-1900 | 9.5 |  |  | 9.5 |  |  | 9.5
 | 35 | 0900-1915 | 9.75 |  |  | 9.75 |  |  | 9.75
 | 36 | 0900-2000 | 10.5 |  |  | 10.5 |  |  | 10.5
 | 37 | 0900-2100 | 11.5 | 1 |  | 11.5 |  |  | 11.5 |  | 1
 | 38 | 0915-1900 | 9.25 |  |  | 9.25 |  |  | 9.25
 | 39 | 0930-1730 | 7.5 |  |  | 7.5 |  |  | 7.5
 | 40 | 0930-2130 | 11.5 | 1.5 |  | 11.5 |  |  | 11.5 |  | 1.5
 | 41 | 1000-1800 | 7.5 |  |  | 7.5 |  |  | 7.5
 | 42 | 1000-1815 | 7.75 |  |  | 7.75 |  |  | 7.75
 | 43 | 1000-1900 | 8.5 |  |  | 8.5 |  |  | 8.5
 | 44 | 1000-2100 | 10.5 | 1 |  | 10.5 |  |  | 10.5 |  | 1
 | 45 | 1000-2115 | 10.75 | 1.25 |  | 10.75 |  |  | 10.75 |  | 1.25
 | 46 | 1000-2200 | 11.5 | 2 |  | 11.5 |  |  | 11.5 |  | 2
 | 47 | 1030-1830 | 7.5 |  |  | 7.5 |  |  | 7.5
 | 48 | 1030-2000 | 9 |  |  | 9 |  |  | 9
 | 49 | 1100-2000 | 8.5 |  |  | 8.5 |  |  | 8.5
 | 50 | 1100-2200 | 10.5 | 2 |  | 10.5 |  |  | 10.5 |  | 2
 | 51 | 1100-2230 | 11 | 2.5 |  | 11 |  |  | 11 |  | 2.5
 | 52 | 1100-2300 | 11.5 | 3 |  | 11.5 |  |  | 11.5 |  | 3
 | 53 | 1200-0000 | 11.5 | 4 |  | 11.5 |  |  | 11.5 |  | 4
 | 54 | 1200-2100 | 8.5 | 1 |  | 8.5 |  |  | 8.5 |  | 1
 | 55 | 1200-2300 | 10.5 | 3 |  | 10.5 |  |  | 10.5 |  | 3
 | 56 | 1300-0000 | 10.5 | 4 |  | 10.5 |  |  | 10.5 |  | 4
 | 57 | 1300-0100 | 11.5 | 5 |  | 10.5 | 1 | 0.5 | 11 |  | 10.5
 | 58 | 1400-0200 | 11.5 | 11.5 |  | 9.5 | 2 | 1.5 | 10 |  | 9.5
 | 59 | 1400-2300 | 8.5 | 3 |  | 8.5 |  |  | 8.5 |  | 9.5
 | 60 | 1500-0100 | 9.5 | 9.5 |  | 8.5 | 1 | 0.5 | 9 |  | 8.5
 | 61 | 1500-0200 | 10.5 | 10.5 |  | 8.5 | 2 | 1.5 | 9 |  | 8.5
 | 62 | 1500-0300 | 11.5 | 11.5 |  | 8.5 | 3 | 2.5 | 9 |  | 8.5
 | 63 | 1600-0000 | 7.5 | 7.5 |  | 7.5 |  |  | 7.5 |  | 7.5
 | 64 | 1600-0200 | 9.5 | 9.5 |  | 7.5 | 2 | 1.5 | 8 |  | 7.5
 | 65 | 1600-0300 | 10.5 | 10.5 |  | 7.5 | 3 | 2.5 | 8 |  | 7.5
 | 66 | 1600-0400 | 11.5 | 11.5 |  | 7.5 | 4 | 3.5 | 8 |  | 7.5
 | 67 | 1630-0130 | 9.5 | 9.5 |  | 7 | 1.5 | 1 | 7.5 |  | 7
 | 68 | 1630-0230 | 10.5 | 10.5 |  | 7 | 2.5 | 2 | 7.5 |  | 7
 | 69 | 1700-0200 | 8.5 | 8.5 |  | 6.5 | 2 | 1.5 | 7 |  | 6.5
 | 70 | 1700-0300 | 9.5 | 9.5 |  | 6.5 | 3 | 2.5 | 7 |  | 6.5
 | 71 | 1800-0400 | 9.5 | 9.5 |  | 5.5 | 4 | 3.5 | 6 |  | 5.5
 | 72 | 1800-0600 | 11.5 | 11.5 |  | 5.5 | 6 | 6 | 5.5 |  | 5.5
 | 73 | 1830-0630 | 11.5 | 11.5 |  | 5 | 6.5 | 6 | 5.5 |  | 5
 | 74 | 1900-0300 | 7.5 | 7.5 |  | 4.5 | 3 | 2.5 | 5.5 |  | 4.5
 | 75 | 1900-0700 | 11.5 | 11.5 |  | 4.5 | 7 | 6.5 | 5 |  | 4.5
 | 76 | 1930-0730 | 11.5 | 11.5 |  | 4 | 7.5 | 7 | 4.5 |  | 4
 | 77 | 2000-0200 | 6 | 6 |  | 4 | 2 | 2 | 4 |  | 4
 | 78 | 2000-0600 | 9.5 | 9.5 |  | 3.5 | 6 | 5.5 | 4 |  | 3.5
 | 79 | 2000-0800 | 11.5 | 11.5 |  | 3.5 | 8 | 7.5 | 4 |  | 3.5
 | 80 | Relief 11.5 | 11.5 | 5.5 | 2.05 | 5.5 | 2.05 | 5.5 | 2.05
 | 81 | Relief 10.5 | 10.5 | 5 | 1.87 | 5 | 1.87 | 5 | 1.87
 | 82 | Relief 9.5 | 9.5 | 4.5 | 1.7 | 4.5 | 1.7 | 4.5 | 1.7
 | 83 | Relief 8.5 | 8.5 | 4 | 1.55 | 4 | 1.55 | 4 | 1.55
 | 84 | Relief 8 | 8 | 3.75 | 1.45 | 3.75 | 1.45 | 3.75 | 1.45
 | 85 | Relief 7.5 | 7.5 | 3.5 | 1.37 | 3.5 | 1.37 | 3.5 | 1.37
 | 86 | Relief 6.5 | 6.5 | 3 | 1.21 | 3 | 1.21 | 3 | 1.21
 | 87 | Relief 6 | 6 | 2.5 | 1.25 | 2.5 | 1.25 | 2.5 | 1.25
 | 88 | Relief 5 | 5 | 2.17 | 1 | 2.17 | 1 | 2.17 | 1
 | 89
 | 90
 |  | Staff on relief or no fixed rota during the period of absence
 |  | For staff who do not work a fixed shift pattern or who have variations in their shift patterns (e.g. periods of “relief” working with no identified rota or individual relief average), the above provides a baseline of how many hours should be entered onto the timesheet for the higher and lower USH rates for each shift.