Spreadsheet: 45364d1244111574-job-hour-tracking-with-pivot-tables-weekly-timesheet-summary
Sheet: Weekly Calcs

 | 2009-01-12 00:00:00 | HOURS | 2009-01-13 00:00:00 | HOURS | 2009-01-14 00:00:00 | HOURS | 2009-01-15 00:00:00 | HOURS | 2009-01-16 00:00:00 | HOURS
 | JOB # |  | JOB # |  | JOB # |  | JOB # |  | JOB #
Date | JOB # | Hours
2009-01-12 00:00:00 | 870 | 1.5 | 870 | 9.5 | 870 | 1.5 | 870 | 1.5 | 830 | 73.5
2009-01-12 00:00:00 | 1223-5567 | 32 | 1223-5567 | 16 | 1223-5567 | 50 | 1223-5567 | 40.5 | 870 | 15
2009-01-12 00:00:00 | 5553-6789 | 18 | 5553-6789 | 6.5 | 5553-6789 | 6.5 | 5553-6789 | 35.5 | 885 | 10.5
2009-01-12 00:00:00 | shop | 17 | 5553-6788 | 1.5 | 5553-6788 | 1.5 | shop | 16 | 895 | 8
2009-01-12 00:00:00 | yard | 9 | shop | 18 | shop | 16.5 | yard | 6.5 | 1234-5678 | 43.5
2009-01-12 00:00:00 | shipping office | 10.5 | 4321-8888 | 6 | yard | 8 | 7445-1235 | 5 | 2356-8967 | 40.5
2009-01-12 00:00:00 | 6789-9433 | 1.5 | 4321-8877 | 2 | 7445-1234 | 3 | shipping office | 10.25 | 3312-6066 | 19.5
2009-01-12 00:00:00 | 5678-2345 | 1.5 | 3345-8676 | 2.5 | 7445-1235 | 5 | 6789-9433 | 2.5 | 5386-8649 | 6
2009-01-12 00:00:00 | shop/tool manitenance | 3 | 3321-3456 | 3 | shipping office | 12 | 5678-2345 | 1.5 | 5547-8888 | 7
2009-01-12 00:00:00 | 4567-7543 | 6 | yard | 2.5 | 6789-9433 | 10.5 | shop/tool manitenance | 3 | 5567-9012 | 45
2009-01-12 00:00:00 | 4568-8467 | 3 | 7445-1234 | 3 | 4567-9089 | 4 | 4567-7543 | 6 | 5649-9016 | 5
2009-01-12 00:00:00 | 4567-8210 | 2.5 | 7445-1235 | 2.5 | 5678-2345 | 1.5 | 4568-8467 | 3 | 5664-9034 | 3
2009-01-12 00:00:00 | 4568-9832 | 2 | 7445-1236 | 1.5 | shop/tool manitenance | 3 | 4567-8210 | 2.5 | 5678-8734 | 6
2009-01-12 00:00:00 | load trucks | 7.5 | 7445-1237 | 1 | 4567-7543 | 5 | 4568-9832 | 2 | 870 | 7.5
2009-01-12 00:00:00 | 3450-6743 | 4.5 | shipping office | 9.5 | 4568-8467 | 3 | load trucks | 7.5 | 8812-5677 | 13.5
2009-01-12 00:00:00 | 5678-3832 | 7 | 6789-9432 | 6.5 | 870 | 2 | 3450-6743 | 4.5 | 5547-3345 | 3
2009-01-12 00:00:00 | 3456-9876 | 5.5 | 6789-9433 | 1.5 | 4567-8211 | 1.5 | 5678-3832 | 7 | 5547-3347 | 2.5
2009-01-12 00:00:00 | sales | 6.5 | 4567-9089 | 4 | 4567-8210 | 2.5 | 3456-9876 | 5.5 | 4999-0987 | 3
2009-01-12 00:00:00 | design | 3 | 5678-2345 | 4 | 4568-9832 | 3.5 | Scruggs elec layout | 3 | 5547-3348 | 6.5
2009-01-12 00:00:00 | 5553-6790 | 8 | shop/tool manitenance | 2 | load trucks | 7.5 | sales | 5.5 | 5547-3349 | 4
2009-01-12 00:00:00 | 1223-5561 | 8 | 4567-7543 | 10 | 3450-6743 | 2.5 | design | 5
2009-01-12 00:00:00 | 5553-6785 | 4 | 2386-9045 | 3 | 5678-3832 | 7
2009-01-12 00:00:00 | 1223-5565 | 9.5 | 4568-8467 | 3 | 3456-9876 | 5.5
2009-01-12 00:00:00 | 5553-6781 | 3 | 870 | 2 | Tarmac schematic | 2
2009-01-12 00:00:00 | 7445-1435 | 5 | 4567-8211 | 3 | sales | 3
2009-01-12 00:00:00 | 5386-8649 | 3 | 4567-8210 | 2.5 | design | 6.5
2009-01-13 00:00:00 | 870 | 9.5 | 4568-9832 | 3.5
2009-01-13 00:00:00 | 1223-5567 | 16 | 7464-9474 | 2.5
2009-01-13 00:00:00 | 5553-6789 | 6.5 | load trucks | 7.5
2009-01-13 00:00:00 | 5553-6788 | 1.5 | 3450-6743 | 5.5
2009-01-13 00:00:00 | shop | 18 | 5678-3832 | 11
2009-01-13 00:00:00 | 4321-8888 | 6 | 3456-9876 | 9.5
2009-01-13 00:00:00 | 4321-8877 | 2 | 4321-7797 | 7
2009-01-13 00:00:00 | 3345-8676 | 2.5 | 896 | 3
2009-01-13 00:00:00 | 3321-3456 | 3 | sales | 5
2009-01-13 00:00:00 | yard | 2.5
2009-01-13 00:00:00 | 7445-1234 | 3
2009-01-13 00:00:00 | 7445-1235 | 2.5
2009-01-13 00:00:00 | 7445-1236 | 1.5
2009-01-13 00:00:00 | 7445-1237 | 1
2009-01-13 00:00:00 | shipping office | 9.5
2009-01-13 00:00:00 | 6789-9432 | 6.5
2009-01-13 00:00:00 | 6789-9433 | 1.5
2009-01-13 00:00:00 | 4567-9089 | 4
2009-01-13 00:00:00 | 5678-2345 | 4
2009-01-13 00:00:00 | shop/tool manitenance | 2
2009-01-13 00:00:00 | 4567-7543 | 10
2009-01-13 00:00:00 | 2386-9045 | 3
2009-01-13 00:00:00 | 4568-8467 | 3
2009-01-13 00:00:00 | 870 | 2
2009-01-13 00:00:00 | 4567-8211 | 3
2009-01-13 00:00:00 | 4567-8210 | 2.5
2009-01-13 00:00:00 | 4568-9832 | 3.5
2009-01-13 00:00:00 | 7464-9474 | 2.5
2009-01-13 00:00:00 | load trucks | 7.5
2009-01-13 00:00:00 | 3450-6743 | 5.5
2009-01-13 00:00:00 | 5678-3832 | 11
2009-01-13 00:00:00 | 3456-9876 | 9.5
2009-01-13 00:00:00 | 4321-7797 | 7
2009-01-13 00:00:00 | 896 | 3
2009-01-13 00:00:00 | sales | 5
2009-01-13 00:00:00 | 870 | 1.5
2009-01-14 00:00:00 | 1223-5567 | 50
2009-01-14 00:00:00 | 5553-6789 | 6.5
2009-01-14 00:00:00 | 5553-6788 | 1.5
2009-01-14 00:00:00 | shop | 16.5
2009-01-14 00:00:00 | yard | 8
2009-01-14 00:00:00 | 7445-1234 | 3
2009-01-14 00:00:00 | 7445-1235 | 5
2009-01-14 00:00:00 | shipping office | 12
2009-01-14 00:00:00 | 6789-9433 | 10.5
2009-01-14 00:00:00 | 4567-9089 | 4
2009-01-14 00:00:00 | 5678-2345 | 1.5
2009-01-14 00:00:00 | shop/tool manitenance | 3
2009-01-14 00:00:00 | 4567-7543 | 5
2009-01-14 00:00:00 | 4568-8467 | 3
2009-01-14 00:00:00 | 870 | 2
2009-01-14 00:00:00 | 4567-8211 | 1.5
2009-01-14 00:00:00 | 4567-8210 | 2.5
2009-01-14 00:00:00 | 4568-9832 | 3.5
2009-01-14 00:00:00 | load trucks | 7.5
2009-01-14 00:00:00 | 3450-6743 | 2.5
2009-01-14 00:00:00 | 5678-3832 | 7
2009-01-14 00:00:00 | 3456-9876 | 5.5
2009-01-14 00:00:00 | Tarmac schematic | 2
2009-01-14 00:00:00 | sales | 3
2009-01-14 00:00:00 | design | 6.5