Spreadsheet: 165563d1341267347-timesheet-with-multiple-jobs-how-to-display-time-per-job-timesheet-breadbowl-oeldere-
Sheet: Sheet1

Job# | IN | OUT | Time | Hours |  |  | Job# | IN | OUT | Time | Hours |  |  | Job# | IN | OUT | Time | Hours |  |  | Job# | IN | OUT | Time | Hours |  |  | Job# | IN | OUT | Time | Hours
 |  |  |  |  | Monday |  |  |  |  |  |  | Tuesday |  |  |  |  |  |  | Wednesday |  |  |  |  |  |  | Thursday |  |  |  |  |  |  | Friday
 |  |  | 1900-01-01 00:00:00 | 0 | 2012-07-02 00:00:00 |  |  |  |  | 1900-01-01 00:00:00 | 0 | 2012-07-03 00:00:00 |  |  |  |  | 1900-01-01 00:00:00 | 0 | 2012-07-04 00:00:00 |  |  |  |  | 1900-01-01 00:00:00 | 0 | 2012-07-05 00:00:00 |  |  |  |  | 1900-01-01 00:00:00 | 0 | 2012-07-06 00:00:00
 |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0
A | 08:00:00 | 09:00:00 | 01:00:00 | 1 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  | Weekly | Totals
B | 09:00:00 | 10:00:00 | 01:00:00 | 1 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0
A | 10:00:00 | 10:30:00 | 00:30:00 | 0.4999999999999996 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  | Monday : | 7.500000000000001 | 7.5
C | 10:30:00 | 11:00:00 | 00:30:00 | 0.4999999999999996 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  | Tuesady : | 0 | 0
B | 11:00:00 | 12:00:00 | 01:00:00 | 1 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  | Wednesday : | 7.500000000000001 | 7.5
A | 13:00:00 | 16:30:00 | 03:30:00 | 3.500000000000001 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  | Thursday : | 0 | 0
 |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  | Holiday | 08:00:00 | 12:00:00 | 04:00:00 | 4 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  | Friday : | 0 | 0
 |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  | 13:00:00 | 16:30:00 | 03:30:00 | 3.500000000000001 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0
 |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  | Totals : | 15 | 15
 |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0
 |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  | Still Need : | 22.5 | 22.5
 |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0
 |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0
 |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0
 |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0
 |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0
 |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0
 |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0
 |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  | just some math:
 |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0
 |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  | 7.5x5= | 37.5
 |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0
 |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  | 37.5-5= | 32.5
 |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0
 |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  | 32.5/4= | 8.125
 |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0
 |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0
 |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 1900-01-01 00:00:00 | 0
 |  |  | Total Hours: | 7.500000000000001 | 0 |  |  |  |  | Total Hours: | 0 |  |  |  |  |  | Total Hours: | 7.500000000000001 | 0 |  |  |  |  | Total Hours: | 0 |  |  |  |  |  | Total Hours: | 0
JOB# | Session 1 | Session 2 | Session 3 | Session 4 | Hours per Job |  | JOB# | Session 1 | Session 2 | Session 3 | Session 4 | Hours per Job |  | JOB# | Session 1 | Session 2 | Session 3 | Session 4 | Hours per Job |  | JOB# | Session 1 | Session 2 | Session 3 | Session 4 | Hours per Job |  | JOB# | Session 1 | Session 2 | Session 3 | Session 4 | Hours per Job
 |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
A | 1 | 0.5 | 3.5 |  | 5 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
B | 1 | 1 |  |  | 2 |  |  |  |  |  |  | 0 |  | Holdiay | 4 | 3.5 |  |  | 7.5 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
C | 0.5 |  |  |  | 0.5 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
 |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
 |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
 |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
 |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
 |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
 |  |  |  | Total Hours: | 7.5 |  |  |  |  |  | Total Hours: | 0 |  |  |  |  |  | Total Hours: | 7.5 |  |  |  |  |  | Total Hours: | 0 |  |  |  |  |  | Total Hours: | 0