Spreadsheet: 376588d1423656358-how-to-sum-values-in-a-column-based-on-2-criteria-timesheet-sample
Sheet: Timesheets 2015

MANHOURS EXPENDED |  |  | TOTAL TURNOVER ON LABOUR |  | STRAIGHT HOURS |  | TRAVEL HOURS |  | HOURS X 1.5 |  | HOURS X 2 |  |  | ACME CORPORATION
 |  |  |  |  |  |  |  |  |  |  |  |  |  | JANUARY | FEBRUARY | [NAME] | APRIL | MAY | [NAME] | JULY | AUGUST | SEPTEMBER | OCTOBER | NOVEMBER | DECEMBER
JOB NUMBER | NAME | DATE | CUSTOMER | [NAME] | START TIME | STOP TIME | TRAVEL TIME | STRAIGHT HOURS | HOURS X 1.5 | HOURS X 2 | DRIVER | TOTAL HOURS
00000 | [NAME] | 2015-01-01 00:00:00 | ACME CORPORATION | ABERDEEN | 07:30:00 | 16:00:00 |  | 8
00000 | [NAME] | 2015-01-02 00:00:00 | ACME CORPORATION | ABERDEEN | 07:30:00 | 15:00:00 |  | 7
00000 | [NAME] | 2015-01-01 00:00:00 | ACME CORPORATION | ABERDEEN | 07:30:00 | 16:00:00 |  | 8
00000 | [NAME] | 2015-01-02 00:00:00 | ACME CORPORATION | ABERDEEN | 07:30:00 | 15:00:00 |  | 7
00000 | [NAME] | 2015-01-01 00:00:00 | ACME CORPORATION | ABERDEEN | 07:30:00 | 16:00:00 |  | 8
00000 | [NAME] | 2015-01-02 00:00:00 | ACME CORPORATION | ABERDEEN | 07:30:00 | 15:00:00 |  | 7
00000 | [NAME] | 2015-01-01 00:00:00 | ACME CORPORATION | ABERDEEN | 07:30:00 | 16:00:00 |  | 8
00000 | [NAME] | 2015-01-02 00:00:00 | ACME CORPORATION | ABERDEEN | 07:30:00 | 15:00:00 |  | 7
00000 | [NAME] | 2015-01-01 00:00:00 | ACME CORPORATION | ABERDEEN | 07:30:00 | 16:00:00 |  | 8
00000 | [NAME] | 2015-01-02 00:00:00 | ACME CORPORATION | ABERDEEN | 07:30:00 | 15:00:00 |  | 7
00000 | [NAME] | 2015-01-01 00:00:00 | ACME CORPORATION | ABERDEEN | 07:30:00 | 16:00:00 |  | 8
00000 | [NAME] | 2015-01-02 00:00:00 | ACME CORPORATION | ABERDEEN | 07:30:00 | 15:00:00 |  | 7
00000 | [NAME] | 2015-01-01 00:00:00 | ACME CORPORATION | ABERDEEN | 07:30:00 | 16:00:00 |  | 8
00000 | [NAME] | 2015-01-01 00:00:00 | ACME CORPORATION | ABERDEEN | 07:30:00 | 16:00:00 |  | 8
00000 | [NAME] | 2015-01-02 00:00:00 | DUPLEX SUPPLIES | GLASGOW | 07:30:00 | 15:00:00 |  | 7
00000 | [NAME] | 2015-01-01 00:00:00 | DUPLEX SUPPLIES | GLASGOW | 07:30:00 | 16:00:00 |  | 8
00000 | [NAME] | 2015-01-02 00:00:00 | DUPLEX SUPPLIES | GLASGOW | 07:30:00 | 15:00:00 |  | 7
00000 | [NAME] | 2015-01-01 00:00:00 | DUPLEX SUPPLIES | GLASGOW | 07:30:00 | 16:00:00 |  | 8
00000 | [NAME] | 2015-01-02 00:00:00 | DUPLEX SUPPLIES | GLASGOW | 07:30:00 | 15:00:00 |  | 7
00000 | [NAME] | 2015-01-01 00:00:00 | DUPLEX SUPPLIES | GLASGOW | 07:30:00 | 16:00:00 |  | 8
00000 | [NAME] | 2015-01-02 00:00:00 | DUPLEX SUPPLIES | GLASGOW | 07:30:00 | 15:00:00 |  | 7
00000 | [NAME] | 2015-01-01 00:00:00 | DUPLEX SUPPLIES | GLASGOW | 07:30:00 | 16:00:00 |  | 8
00000 | [NAME] | 2015-01-02 00:00:00 | DUPLEX SUPPLIES | GLASGOW | 07:30:00 | 15:00:00 |  | 7
00000 | [NAME] | 2015-01-01 00:00:00 | DUPLEX SUPPLIES | GLASGOW | 07:30:00 | 16:00:00 |  | 8
00000 | [NAME] | 2015-01-02 00:00:00 | DUPLEX SUPPLIES | GLASGOW | 07:30:00 | 15:00:00 |  | 7
00000 | [NAME] | 2015-01-01 00:00:00 | DUPLEX SUPPLIES | GLASGOW | 07:30:00 | 16:00:00 |  | 8
00000 | [NAME] | 2015-01-02 00:00:00 | DUPLEX SUPPLIES | GLASGOW | 07:30:00 | 15:00:00 |  | 7
00000 | [NAME] | 2015-01-01 00:00:00 | DUPLEX SUPPLIES | GLASGOW | 07:30:00 | 16:00:00 |  | 8
00000 | [NAME] | 2015-01-02 00:00:00 | DUPLEX SUPPLIES | GLASGOW | 07:30:00 | 15:00:00 |  | 7
00000 | [NAME] | 2015-01-01 00:00:00 | DUPLEX SUPPLIES | GLASGOW | 07:30:00 | 16:00:00 |  | 8