Spreadsheet: 548445d1511138689-timesheet-time-calculation-for-multiple-jobs-type-mobile_timesheet_v1
Sheet: Sheet1

COMPANY LOGO |  |  |  |  | ENGINEER TIME SHEETS
 |  |  |  |  | ENGINEER |  | ENG 1 |  |  | WEEK ENDING DATE |  |  | 2017-11-19 00:00:00
 |  |  |  |  | VAN REG |  | VAN 1 |  |  | WEEK START MILEAGE |  |  | 12345
 |  |  |  |  | HOURS CLAIMED |  |  |  |  | WEEK END MILEAGE |  |  | 12346
 |  |  |  |  | PRIVATE MILEAGE |  | 0 |  |  | CALLOUT HOURS CLAIMED |  |  | 0
DAY | DOCKET | CONTRACT | JOB | SITE DETAILS |  |  | TRAVEL | TRAVEL | SITE |  | HRS | JOB TYPE | FINISHED | Is this
 |  |  |  |  |  |  | TO SITE | BAND | START | FINISH |  |  | Yes or No | a revisit?
 |  |  |  | SUB TOTAL |  |  |  |  | - | -
[NAME] |  |  |  |  | EXTRA WORK HOURS |  |  |  |  | SIGNATURE
REPAIR HOURS |  |  |  |  | OFFICE HOURS
INSTALL HOURS |  |  |  |  | OTHER WORK HOURS
WEEK_DAYS | ENGINEERS | CARS_REGS |  | JOB_TYPE |  |  | TRAVEL_TIME |  |  | TIME_PICKER |  | YES_NO | [NAME]
1 | ENG 1 | VAN 1 |  | MAINTENANCE |  |  | 0.25 |  |  | 08:00:00 |  | YES | A
2 | ENG 2 | VAN 2 |  | REPAIR |  |  | 0.5 |  |  | 08:15:00 |  | NO | B
3 | ENG 3 | VAN 3 |  | INSTALL |  |  | 0.75 |  |  | 08:30:00 |  |  | C
4 | ENG 4 | VAN 4 |  | EXTRA WORK |  |  | 1 |  |  | 08:45:00 |  |  | D
5 | ENG 5 | VAN 5 |  | OFFICE |  |  | 1.25 |  |  | 09:00:00
6 | ENG 7 | VAN 6 |  | OTHER |  |  | 1.5 |  |  | 09:15:00
7 |  |  |  |  |  |  | 1.75 |  |  | 09:30:00
8 |  |  |  |  |  |  | 2 |  |  | 09:45:00
9 |  |  |  |  |  |  | 2.25 |  |  | 10:00:00
10 |  |  |  |  |  |  | 2.5 |  |  | 10:15:00
11 |  |  |  |  |  |  | 2.75 |  |  | 10:30:00
12 |  |  |  |  |  |  | 3 |  |  | 10:45:00
13 |  |  |  |  |  |  | 3.25 |  |  | 11:00:00
14 |  |  |  |  |  |  | 3.5 |  |  | 11:15:00
15 |  |  |  |  |  |  | 3.75 |  |  | 11:30:00
16 |  |  |  |  |  |  | 4 |  |  | 11:45:00
17 |  |  |  |  |  |  | 4.25 |  |  | 12:00:00
18 |  |  |  |  |  |  | 4.5 |  |  | 12:15:00
19 |  |  |  |  |  |  | 4.75 |  |  | 12:30:00
20 |  |  |  |  |  |  | 5 |  |  | 12:45:00
21 |  |  |  |  |  |  |  |  |  | 13:00:00
22 |  |  |  |  |  |  |  |  |  | 13:15:00
23 |  |  |  |  |  |  |  |  |  | 13:30:00
24 |  |  |  |  |  |  |  |  |  | 13:45:00
25 |  |  |  |  |  |  |  |  |  | 14:00:00
26 |  |  |  |  |  |  |  |  |  | 14:15:00
27 |  |  |  |  |  |  |  |  |  | 14:30:00
28 |  |  |  |  |  |  |  |  |  | 14:45:00
29 |  |  |  |  |  |  |  |  |  | 15:00:00
30 |  |  |  |  |  |  |  |  |  | 15:15:00
31 |  |  |  |  |  |  |  |  |  | 15:30:00
 |  |  |  |  |  |  |  |  |  | 15:45:00
 |  |  |  |  |  |  |  |  |  | 16:00:00
 |  |  |  |  |  |  |  |  |  | 16:15:00
 |  |  |  |  |  |  |  |  |  | 16:30:00
 |  |  |  |  |  |  |  |  |  | 16:45:00
 |  |  |  |  |  |  |  |  |  | 17:00:00
 |  |  |  |  |  |  |  |  |  | 17:15:00
 |  |  |  |  |  |  |  |  |  | 17:30:00
 |  |  |  |  |  |  |  |  |  | 17:45:00
 |  |  |  |  |  |  |  |  |  | 18:00:00
 |  |  |  |  |  |  |  |  |  | 18:15:00
 |  |  |  |  |  |  |  |  |  | 18:30:00
 |  |  |  |  |  |  |  |  |  | 18:45:00
 |  |  |  |  |  |  |  |  |  | 19:00:00
 |  |  |  |  |  |  |  |  |  | 19:15:00
 |  |  |  |  |  |  |  |  |  | 19:30:00
 |  |  |  |  |  |  |  |  |  | 19:45:00
 |  |  |  |  |  |  |  |  |  | 20:00:00
 |  |  |  |  |  |  |  |  |  | 20:15:00
 |  |  |  |  |  |  |  |  |  | 20:30:00
 |  |  |  |  |  |  |  |  |  | 20:45:00
 |  |  |  |  |  |  |  |  |  | 21:00:00
 |  |  |  |  |  |  |  |  |  | 21:15:00
 |  |  |  |  |  |  |  |  |  | 21:30:00
 |  |  |  |  |  |  |  |  |  | 21:45:00
 |  |  |  |  |  |  |  |  |  | 22:00:00
 |  |  |  |  |  |  |  |  |  | 22:15:00
 |  |  |  |  |  |  |  |  |  | 22:30:00
 |  |  |  |  |  |  |  |  |  | 22:45:00
 |  |  |  |  |  |  |  |  |  | 23:00:00
 |  |  |  |  |  |  |  |  |  | 23:15:00
 |  |  |  |  |  |  |  |  |  | 23:30:00
 |  |  |  |  |  |  |  |  |  | 23:45:00
 |  |  |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  |  |  | 00:15:00
 |  |  |  |  |  |  |  |  |  | 00:30:00
 |  |  |  |  |  |  |  |  |  | 00:45:00
 |  |  |  |  |  |  |  |  |  | 01:00:00
 |  |  |  |  |  |  |  |  |  | 01:15:00
 |  |  |  |  |  |  |  |  |  | 01:30:00
 |  |  |  |  |  |  |  |  |  | 01:45:00
 |  |  |  |  |  |  |  |  |  | 02:00:00
 |  |  |  |  |  |  |  |  |  | 02:15:00
 |  |  |  |  |  |  |  |  |  | 02:30:00
 |  |  |  |  |  |  |  |  |  | 02:45:00
 |  |  |  |  |  |  |  |  |  | 03:00:00
 |  |  |  |  |  |  |  |  |  | 03:15:00
 |  |  |  |  |  |  |  |  |  | 03:30:00
 |  |  |  |  |  |  |  |  |  | 03:45:00
 |  |  |  |  |  |  |  |  |  | 04:00:00
 |  |  |  |  |  |  |  |  |  | 04:15:00
 |  |  |  |  |  |  |  |  |  | 04:30:00
 |  |  |  |  |  |  |  |  |  | 04:45:00
 |  |  |  |  |  |  |  |  |  | 05:00:00
 |  |  |  |  |  |  |  |  |  | 05:15:00
 |  |  |  |  |  |  |  |  |  | 05:30:00
 |  |  |  |  |  |  |  |  |  | 05:45:00
 |  |  |  |  |  |  |  |  |  | 06:00:00
 |  |  |  |  |  |  |  |  |  | 06:15:00
 |  |  |  |  |  |  |  |  |  | 06:30:00
 |  |  |  |  |  |  |  |  |  | 06:45:00
 |  |  |  |  |  |  |  |  |  | 07:00:00
 |  |  |  |  |  |  |  |  |  | 07:15:00
 |  |  |  |  |  |  |  |  |  | 07:30:00
 |  |  |  |  |  |  |  |  |  | 07:45:00