Spreadsheet: 147644d1332905198-cost-split-into-different-periods-sample-data
Sheet: Data

Start | End | Name | Hours Worked | Amount Paid | Cost Centre
27/03/12 12:00 | 27/03/12 17:00 | ADDERLEY | 5 | 103.74 | 1234
25/03/12 06:00 | 25/03/12 14:00 | [NAME] | 7.5 | 186.73 | 1391
26/03/12 06:00 | 26/03/12 14:00 | [NAME] | 7.5 | 186.73 | 1391
27/03/12 10:00 | 27/03/12 18:00 | [NAME] | 7.5 | 186.73 | 1381
25/03/12 14:00 | 25/03/12 22:06 | ANGELO | 7.6 | 157.68 | 1861
26/03/12 14:00 | 26/03/12 22:06 | ANGELO | 7.6 | 157.68 | 1861
25/03/12 16:45 | 25/03/12 22:30 | APIATA | 5.75 | 119.3 | 1235
26/03/12 17:30 | 26/03/12 20:30 | APIATA | 3 | 62.24 | 1236
27/03/12 18:00 | 27/03/12 21:15 | APIATA | 3.25 | 67.43 | 1236
25/03/12 11:30 | 25/03/12 23:30 | ARCHIE | 3.75 | 93.36 | 1235
25/03/12 11:30 | 25/03/12 23:30 | ARCHIE | 6 | 149.38 | 1259
26/03/12 06:48 | 26/03/12 13:03 | AUSTIN | 6.25 | 129.67 | 1349
27/03/12 06:30 | 27/03/12 14:00 | AUSTIN | 4 | 82.99 | 1232
27/03/12 06:30 | 27/03/12 14:00 | AUSTIN | 2.25 | 46.68 | 1349
27/03/12 09:30 | 27/03/12 18:00 | BALDWIN | 8 | 165.98 | 1349
26/03/12 12:00 | 26/03/12 23:15 | BLACKFORD | 6.75 | 140.05 | 1234
26/03/12 12:00 | 26/03/12 23:15 | BLACKFORD | 2 | 41.49 | 1234
25/03/12 11:30 | 25/03/12 23:00 | BORN | 7.5 | 186.73 | 1234
27/03/12 23:00 | 28/03/12 06:00 | BORN | 6.5 | 161.83 | 1234
26/03/12 07:00 | 26/03/12 15:00 | BOWIE | 7 | 145.23 | 1232
27/03/12 06:15 | 27/03/12 16:00 | BOWIE | 9.25 | 191.91 | 1232
27/03/12 07:00 | 27/03/12 15:30 | BRECHELT | 7.5 | 186.73 | 1232
25/03/12 07:00 | 25/03/12 15:00 | BROWN | 7.5 | 186.73 | 1234
26/03/12 14:00 | 26/03/12 22:30 | BUKSH | 8 | 165.98 | 1161
27/03/12 14:00 | 27/03/12 22:30 | BUKSH | 8 | 165.98 | 1161
25/03/12 06:00 | 25/03/12 14:06 | BURKE | 7.6 | 157.68 | 1861
26/03/12 06:00 | 26/03/12 14:06 | BURKE | 7.6 | 157.68 | 1861
27/03/12 06:00 | 27/03/12 14:06 | BURKE | 7.6 | 157.68 | 1861
25/03/12 23:00 | 26/03/12 07:15 | CAMPBELL | 7.75 | 192.95 | 1234
26/03/12 23:00 | 27/03/12 06:00 | CAMPBELL | 6.5 | 161.83 | 1234
25/03/12 18:30 | 26/03/12 02:15 | CANNING | 7.75 | 137.25 | 1234
27/03/12 19:03 | 28/03/12 01:03 | CANNING | 6 | 106.26 | 1234
26/03/12 05:15 | 26/03/12 14:45 | CARROLL | 9.5 | 0 | 1381
26/03/12 05:15 | 26/03/12 14:45 | CARROLL | 9.5 | 219.08 | 1381
27/03/12 06:00 | 27/03/12 16:00 | CARROLL | 9.5 | 219.08 | 1381
25/03/12 07:00 | 25/03/12 15:00 | CARROLL | 7.5 | 186.73 | 1434
26/03/12 18:00 | 26/03/12 22:00 | CASTRO | 4 | 99.59 | 1391
27/03/12 18:00 | 27/03/12 22:00 | CASTRO | 4 | 99.59 | 1391
25/03/12 11:00 | 25/03/12 23:00 | CLARKE | 9.5 | 197.1 | 1234
26/03/12 11:00 | 26/03/12 23:00 | CLARKE | 9.5 | 197.1 | 1234
27/03/12 18:00 | 27/03/12 23:00 | CLARKE | 5 | 103.74 | 1234
25/03/12 08:00 | 25/03/12 16:00 | COLLINS | 7.5 | 172.96 | 1236
26/03/12 11:00 | 26/03/12 21:30 | COLLINS | 6.5 | 134.86 | 1235
27/03/12 15:00 | 27/03/12 23:00 | COLLINS | 7.5 | 172.96 | 1236
25/03/12 07:30 | 25/03/12 12:15 | COMPOS | 4.75 | 118.26 | 1232
27/03/12 17:00 | 27/03/12 22:30 | COMPOS | 5.5 | 136.93 | 1232
25/03/12 16:00 | 25/03/12 21:30 | COOTE | 5.5 | 136.93 | 1232
26/03/12 16:00 | 26/03/12 22:00 | COOTE | 6 | 149.38 | 1349
27/03/12 17:30 | 27/03/12 22:30 | COOTE | 5 | 124.48 | 1349
26/03/12 06:00 | 26/03/12 16:00 | CRANFIELD | 9.5 | 438.17 | 1381
26/03/12 16:00 | 26/03/12 21:00 | CRAVEN | 5 | 124.48 | 1381
27/03/12 08:00 | 27/03/12 16:30 | CRAVEN | 8 | 199.17 | 1381
25/03/12 11:00 | 25/03/12 18:00 | [NAME] | 6.5 | 134.86 | 1259
26/03/12 11:00 | 26/03/12 18:00 | [NAME] | 6.5 | 134.86 | 1259
27/03/12 10:15 | 27/03/12 22:00 | [NAME] | 4.75 | 0 | 1235
27/03/12 10:15 | 27/03/12 22:00 | [NAME] | 4 | 0 | 1259
25/03/12 21:00 | 26/03/12 07:15 | DAVIES | 9.75 | 242.74 | 1323
26/03/12 22:00 | 27/03/12 02:30 | DAVIES | 4.5 | 112.04 | 1323
26/03/12 18:00 | 26/03/12 23:00 | DAVIES | 5 | 124.48 | 1234
27/03/12 12:00 | 27/03/12 17:00 | DAVIES | 5 | 124.48 | 1234
25/03/12 11:30 | 25/03/12 22:00 | DE GUZMAN | 1.67 | 41.49 | 1235
25/03/12 11:30 | 25/03/12 22:00 | DE GUZMAN | 1.33 | 33.2 | 1236
25/03/12 11:30 | 25/03/12 22:00 | DE GUZMAN | 7 | 174.28 | 1861
27/03/12 18:00 | 27/03/12 22:00 | DE GUZMAN | 4 | 99.59 | 1235
26/03/12 17:00 | 26/03/12 23:00 | [NAME] | 5.5 | 136.93 | 1234
27/03/12 11:00 | 27/03/12 21:00 | [NAME] | 7 | 174.28 | 1234
25/03/12 11:30 | 25/03/12 20:00 | DHIRASASNA | 8 | 199.17 | 1161
26/03/12 22:00 | 27/03/12 06:30 | DHIRASASNA | 8 | 199.17 | 1161
27/03/12 19:00 | 28/03/12 03:30 | DHIRASASNA | 8 | 199.17 | 1161
26/03/12 07:00 | 26/03/12 15:30 | DIALLO | 8 | 199.17 | 1381
27/03/12 07:00 | 27/03/12 15:30 | DIALLO | 8 | 199.17 | 1381
25/03/12 17:45 | 25/03/12 22:15 | DORN | 4.5 | 112.04 | 1232
26/03/12 17:45 | 26/03/12 22:45 | DORN | 5 | 124.48 | 1232
27/03/12 14:00 | 27/03/12 22:06 | EDLER | 7.6 | 157.68 | 1861
25/03/12 22:00 | 26/03/12 06:00 | EGAN | 7.5 | 186.73 | 1391
26/03/12 22:00 | 27/03/12 06:00 | EGAN | 7.5 | 186.73 | 1391
26/03/12 18:30 | 26/03/12 22:30 | ELLIS | 4 | 99.59 | 1235
27/03/12 11:00 | 27/03/12 21:30 | ELLIS | 3 | 74.69 | 1235
27/03/12 11:00 | 27/03/12 21:30 | ELLIS | 3.5 | 87.14 | 1236
27/03/12 06:00 | 27/03/12 14:00 | EMILE | 7.5 | 155.61 | 1391
25/03/12 07:00 | 25/03/12 15:00 | FLETCHER | 7.5 | 186.73 | 1234
26/03/12 12:00 | 26/03/12 21:00 | FLETCHER | 8.5 | 211.62 | 1234
27/03/12 17:00 | 27/03/12 23:00 | FLETCHER | 5.5 | 136.93 | 1234
26/03/12 07:00 | 26/03/12 15:00 | FORSTER | 7.5 | 155.61 | 1372
27/03/12 07:00 | 27/03/12 15:00 | FORSTER | 7.5 | 155.61 | 1372
25/03/12 09:00 | 25/03/12 15:06 | FOXWELL | 5.6 | 116.19 | 1407
27/03/12 07:00 | 27/03/12 15:06 | FOXWELL | 7.6 | 157.68 | 1407
26/03/12 07:00 | 26/03/12 15:00 | FOXWELL | 7.5 | 194.33 | 1841
25/03/12 06:00 | 25/03/12 14:06 | GALEA | 7.6 | 157.68 | 1861
26/03/12 06:00 | 26/03/12 14:06 | GALEA | 7.6 | 157.68 | 1861
27/03/12 14:00 | 27/03/12 22:06 | GALEA | 7.6 | 157.68 | 1861
25/03/12 17:45 | 25/03/12 22:15 | GALLEGOS | 4.5 | 112.04 | 1232
27/03/12 09:00 | 27/03/12 15:00 | GOODRICK | 5.5 | 136.93 | 1234
26/03/12 07:00 | 26/03/12 15:15 | GRANT | 7.75 | 192.95 | 1234
25/03/12 17:30 | 25/03/12 22:45 | GREEN | 5.25 | 130.71 | 1235
25/03/12 17:00 | 26/03/12 00:00 | [NAME] | 6.5 | 0 | 1234
25/03/12 12:00 | 25/03/12 21:15 | HALL | 8.75 | 217.85 | 1234
26/03/12 12:00 | 26/03/12 17:00 | HALL | 4.5 | 112.04 | 1372
27/03/12 17:00 | 27/03/12 23:00 | HALL | 5.5 | 136.93 | 1372
25/03/12 17:00 | 25/03/12 23:00 | HENDERSON | 5.5 | 136.93 | 1372
26/03/12 17:00 | 26/03/12 23:00 | HENDERSON | 5.5 | 136.93 | 1372
25/03/12 14:00 | 25/03/12 22:00 | HERNANDEZ | 7.5 | 186.73 | 1391
25/03/12 15:00 | 26/03/12 00:30 | HIAM | 9 | 224.07 | 1234
25/03/12 17:30 | 26/03/12 02:15 | HODDER | 2.25 | 56.02 | 1323
25/03/12 17:30 | 26/03/12 02:15 | HODDER | 6 | 149.38 | 1325
26/03/12 11:30 | 26/03/12 22:30 | HODGSON | 8.5 | 211.62 | 1235
26/03/12 11:30 | 26/03/12 22:30 | HODGSON | 1 | 24.9 | 1236
27/03/12 16:45 | 27/03/12 22:30 | HODGSON | 5.75 | 143.16 | 1235
25/03/12 23:00 | 26/03/12 07:30 | HOLM | 8 | 184.49 | 1323
26/03/12 23:00 | 27/03/12 07:30 | HOLM | 8 | 184.49 | 1323
27/03/12 23:00 | 28/03/12 07:30 | HOLM | 8 | 184.49 | 1323
25/03/12 16:50 | 25/03/12 22:50 | HOOI | 6 | 124.48 | 1233
26/03/12 07:00 | 26/03/12 15:30 | HUNTER | 8 | 184.49 | 1234
27/03/12 07:00 | 27/03/12 15:30 | HUNTER | 8 | 184.49 | 1234
25/03/12 12:00 | 25/03/12 21:45 | [NAME] | 5.25 | 130.71 | 1235
25/03/12 12:00 | 25/03/12 21:45 | [NAME] | 3.75 | 93.36 | 1236
26/03/12 10:30 | 26/03/12 21:45 | [NAME] | 3.75 | 93.36 | 1236
26/03/12 10:30 | 26/03/12 21:45 | [NAME] | 4 | 99.59 | 1236
25/03/12 23:00 | 26/03/12 07:00 | JEFFRIES | 7.5 | 186.73 | 1372
26/03/12 23:00 | 27/03/12 07:00 | JEFFRIES | 7.5 | 186.73 | 1372
27/03/12 23:00 | 28/03/12 07:00 | JEFFRIES | 7.5 | 186.73 | 1372
25/03/12 06:00 | 25/03/12 14:30 | [NAME] | 8 | 184.49 | 1161
26/03/12 07:45 | 26/03/12 15:45 | [NAME] | 1.33 | 0 | 1161
26/03/12 07:45 | 26/03/12 15:45 | [NAME] | 1.33 | 0 | 1161
26/03/12 07:45 | 26/03/12 15:45 | [NAME] | 1.33 | 0 | 1161
26/03/12 07:45 | 26/03/12 15:45 | [NAME] | 1.33 | 0 | 1161
26/03/12 07:45 | 26/03/12 15:45 | [NAME] | 1.33 | 0 | 1161
26/03/12 07:45 | 26/03/12 15:45 | [NAME] | 1.33 | 0 | 1161
27/03/12 09:00 | 27/03/12 17:30 | [NAME] | 8 | 165.98 | 1161
25/03/12 06:00 | 25/03/12 14:30 | JONES | 8 | 165.98 | 1161
25/03/12 10:15 | 25/03/12 21:30 | KALLIDUMBIL | 5 | 124.48 | 1235
25/03/12 10:15 | 25/03/12 21:30 | KALLIDUMBIL | 3.5 | 87.14 | 1236
25/03/12 08:35 | 25/03/12 15:35 | KEARNEY | 7 | 145.23 | 1259
26/03/12 09:10 | 26/03/12 17:40 | KEARNEY | 1.42 | 29.39 | 1235
26/03/12 09:10 | 26/03/12 17:40 | KEARNEY | 1.42 | 29.39 | 1235
26/03/12 09:10 | 26/03/12 17:40 | KEARNEY | 1.42 | 29.39 | 1259
26/03/12 09:10 | 26/03/12 17:40 | KEARNEY | 1.42 | 29.39 | 1236
26/03/12 09:10 | 26/03/12 17:40 | KEARNEY | 1.42 | 29.39 | 1236
26/03/12 09:10 | 26/03/12 17:40 | KEARNEY | 1.42 | 29.39 | 1861
27/03/12 11:15 | 27/03/12 18:15 | KEARNEY | 1.17 | 24.21 | 1235
27/03/12 11:15 | 27/03/12 18:15 | KEARNEY | 1.17 | 24.21 | 1235
27/03/12 11:15 | 27/03/12 18:15 | KEARNEY | 1.17 | 24.21 | 1259
27/03/12 11:15 | 27/03/12 18:15 | KEARNEY | 1.17 | 24.21 | 1236
27/03/12 11:15 | 27/03/12 18:15 | KEARNEY | 1.17 | 24.21 | 1236
27/03/12 11:15 | 27/03/12 18:15 | KEARNEY | 1.17 | 24.21 | 1861
25/03/12 16:00 | 26/03/12 00:30 | KONG | 8 | 165.98 | 1161
26/03/12 00:00 | 26/03/12 08:00 | KONG | 1.33 | 27.66 | 1161
26/03/12 00:00 | 26/03/12 08:00 | KONG | 1.33 | 27.66 | 1161