Spreadsheet: 82285d1282284409-problem-calculating-hours-worked-beteen-two-dates-hours-worked
Sheet: Sheet1

enquiry_received_date | enquiry_received_time | quote_sent_date | quote_sent_time
2010-07-19 00:00:00 | 12 | 2010-07-20 00:00:00 | 10
2010-07-07 00:00:00 | 8 | 2010-07-09 00:00:00 | 11
2010-07-21 00:00:00 | 8 | 2010-07-22 00:00:00 | 13
2010-07-13 00:00:00 | 8 | 2010-07-20 00:00:00 | 8
2010-07-21 00:00:00 | 12 | 2010-07-28 00:00:00 | 16
2010-07-22 00:00:00 | 11 | 2010-07-22 00:00:00 | 14
2010-07-22 00:00:00 | 17 | 2010-07-23 00:00:00 | 17
2010-07-27 00:00:00 | 13 | 2010-07-30 00:00:00 | 15
2010-07-27 00:00:00 | 11 | 2010-08-03 00:00:00 | 11
2010-07-27 00:00:00 | 11 | 2010-07-30 00:00:00 | 15
2010-07-22 00:00:00 | 10 | 2010-07-23 00:00:00 | 13
2010-07-27 00:00:00 | 8 | 2010-07-27 00:00:00 | 9
2010-07-05 00:00:00 | 14 | 2010-07-05 00:00:00 | 16
2010-07-14 00:00:00 | 9 | 2010-07-14 00:00:00 | 15
2010-07-27 00:00:00 | 11 | 2010-08-03 00:00:00 | 15
2010-07-27 00:00:00 | 15 | 2010-07-28 00:00:00 | 13
2010-07-06 00:00:00 | 10 | 2010-07-07 00:00:00 | 15
2010-07-13 00:00:00 | 9 | 2010-07-15 00:00:00 | 13
2010-07-13 00:00:00 | 8 | 2010-07-13 00:00:00 | 16
2010-07-13 00:00:00 | 8 | 2010-07-15 00:00:00 | 13
2010-07-20 00:00:00 | 13 | 2010-07-21 00:00:00 | 15
2010-07-18 00:00:00 | 10 | 2010-07-20 00:00:00 | 16
2010-07-21 00:00:00 | 8 | 2010-07-27 00:00:00 | 12
2010-07-26 00:00:00 | 8 | 2010-07-29 00:00:00 | 10
2010-07-26 00:00:00 | 15 | 2010-07-29 00:00:00 | 14
2010-07-27 00:00:00 | 15 | 2010-08-04 00:00:00 | 10
2010-07-29 00:00:00 | 12 | 2010-08-03 00:00:00 | 8
2010-07-29 00:00:00 | 11 | 2010-07-29 00:00:00 | 16
2010-07-19 00:00:00 | 16 | 2010-07-19 00:00:00 | 17
2010-07-26 00:00:00 | 10 | 2010-07-27 00:00:00 | 12
2010-07-19 00:00:00 | 8 | 2010-07-19 00:00:00 | 16
2010-07-01 00:00:00 | 16 | 2010-07-01 00:00:00 | 17
2010-07-16 00:00:00 | 8 | 2010-07-28 00:00:00 | 11
2010-07-29 00:00:00 | 14 | 2010-07-30 00:00:00 | 15
2010-07-15 00:00:00 | 14 | 2010-07-21 00:00:00 | 17
2010-07-21 00:00:00 | 11 | 2010-07-21 00:00:00 | 16
2010-07-21 00:00:00 | 14 | 2010-07-26 00:00:00 | 13
2010-07-26 00:00:00 | 8 | 2010-07-26 00:00:00 | 17
2010-07-30 00:00:00 | 10 | 2010-08-03 00:00:00 | 15
2010-07-01 00:00:00 | 12 | 2010-07-02 00:00:00 | 12
2010-07-01 00:00:00 | 10 | 2010-07-02 00:00:00 | 11
2010-07-12 00:00:00 | 8 | 2010-07-12 00:00:00 | 15
2010-07-22 00:00:00 | 10 | 2010-07-22 00:00:00 | 11
2010-07-05 00:00:00 | 15 | 2010-07-05 00:00:00 | 17
2010-07-07 00:00:00 | 10 | 2010-07-09 00:00:00 | 11
2010-07-13 00:00:00 | 15 | 2010-07-13 00:00:00 | 15
2010-07-14 00:00:00 | 13 | 2010-07-15 00:00:00 | 11
2010-07-29 00:00:00 | 14 | 2010-07-30 00:00:00 | 15
2010-07-22 00:00:00 | 12 | 2010-07-22 00:00:00 | 17
2010-07-20 00:00:00 | 14 | 2010-08-03 00:00:00 | 16
2010-07-22 00:00:00 | 10 | 2010-07-22 00:00:00 | 11
2010-07-05 00:00:00 | 8 | 2010-07-05 00:00:00 | 13
2010-07-12 00:00:00 | 8 | 2010-07-15 00:00:00 | 15
2010-07-09 00:00:00 | 8 | 2010-07-15 00:00:00 | 16
2010-07-21 00:00:00 | 13 | 2010-08-10 00:00:00 | 13
2010-07-16 00:00:00 | 8 | 2010-07-16 00:00:00 | 16
2010-07-19 00:00:00 | 13 | 2010-07-21 00:00:00 | 15
2010-07-22 00:00:00 | 8 | 2010-07-27 00:00:00 | 17
2010-07-22 00:00:00 | 10 | 2010-07-28 00:00:00 | 15
2010-07-29 00:00:00 | 12 | 2010-08-02 00:00:00 | 16
2010-07-23 00:00:00 | 8 | 2010-07-28 00:00:00 | 15
2010-07-27 00:00:00 | 10 | 2010-07-27 00:00:00 | 12
2010-07-27 00:00:00 | 10 | 2010-07-27 00:00:00 | 12
2010-07-30 00:00:00 | 10 | 2010-08-02 00:00:00 | 14
2010-07-05 00:00:00 | 8 | 2010-07-05 00:00:00 | 9
2010-07-07 00:00:00 | 8 | 2010-07-07 00:00:00 | 10
2010-07-06 00:00:00 | 8 | 2010-07-06 00:00:00 | 12
2010-07-12 00:00:00 | 8 | 2010-07-12 00:00:00 | 14
2010-07-14 00:00:00 | 8 | 2010-07-23 00:00:00 | 14
2010-07-19 00:00:00 | 10 | 2010-07-23 00:00:00 | 14
2010-07-08 00:00:00 | 8 | 2010-07-09 00:00:00 | 10
2010-07-20 00:00:00 | 15 | 2010-07-21 00:00:00 | 16
2010-07-01 00:00:00 | 11 | 2010-07-07 00:00:00 | 17
2010-07-01 00:00:00 | 12 | 2010-07-07 00:00:00 | 17
2010-07-05 00:00:00 | 14 | 2010-07-13 00:00:00 | 17
2010-07-08 00:00:00 | 8 | 2010-07-08 00:00:00 | 12
2010-07-20 00:00:00 | 16 | 2010-07-21 00:00:00 | 12
2010-07-22 00:00:00 | 15 | 2010-07-28 00:00:00 | 17
2010-07-28 00:00:00 | 8 | 2010-08-02 00:00:00 | 15
2010-07-28 00:00:00 | 8 | 2010-08-03 00:00:00 | 17
2010-07-28 00:00:00 | 9 | 2010-07-28 00:00:00 | 10
2010-07-02 00:00:00 | 16 | 2010-07-05 00:00:00 | 10
2010-07-02 00:00:00 | 16 | 2010-07-05 00:00:00 | 10
2010-07-05 00:00:00 | 13 | 2010-07-06 00:00:00 | 14
2010-07-05 00:00:00 | 8 | 2010-07-05 00:00:00 | 17
2010-07-05 00:00:00 | 14 | 2010-07-06 00:00:00 | 16
2010-07-07 00:00:00 | 8 | 2010-07-08 00:00:00 | 17
2010-07-16 00:00:00 | 8 | 2010-07-20 00:00:00 | 16
2010-07-16 00:00:00 | 8 | 2010-07-20 00:00:00 | 14
2010-07-08 00:00:00 | 12 | 2010-07-08 00:00:00 | 15
2010-07-12 00:00:00 | 8 | 2010-07-12 00:00:00 | 10
2010-07-05 00:00:00 | 16 | 2010-07-06 00:00:00 | 16
2010-07-05 00:00:00 | 16 | 2010-07-07 00:00:00 | 8
2010-07-05 00:00:00 | 16 | 2010-07-06 00:00:00 | 16
2010-07-30 00:00:00 | 13 | 2010-08-02 00:00:00 | 10
2010-07-08 00:00:00 | 9 | 2010-07-13 00:00:00 | 17
2010-07-07 00:00:00 | 8 | 2010-07-07 00:00:00 | 9
2010-07-22 00:00:00 | 8 | 2010-07-22 00:00:00 | 16
2010-07-13 00:00:00 | 14 | 2010-07-19 00:00:00 | 14
2010-07-05 00:00:00 | 8 | 2010-07-05 00:00:00 | 17
2010-07-06 00:00:00 | 8 | 2010-07-06 00:00:00 | 9
2010-07-13 00:00:00 | 9 | 2010-07-22 00:00:00 | 16
2010-07-09 00:00:00 | 8 | 2010-07-16 00:00:00 | 17
2010-07-15 00:00:00 | 16 | 2010-07-21 00:00:00 | 16
2010-07-06 00:00:00 | 8 | 2010-07-06 00:00:00 | 14
2010-07-21 00:00:00 | 15 | 2010-07-26 00:00:00 | 10
2010-07-20 00:00:00 | 14 | 2010-07-21 00:00:00 | 10
2010-07-22 00:00:00 | 8 | 2010-07-27 00:00:00 | 16
2010-07-21 00:00:00 | 13 | 2010-07-22 00:00:00 | 14
2010-07-26 00:00:00 | 12 | 2010-07-28 00:00:00 | 13
2010-07-28 00:00:00 | 8 | 2010-07-29 00:00:00 | 14
2010-07-26 00:00:00 | 9 | 2010-07-26 00:00:00 | 10
2010-07-01 00:00:00 | 17 | 2010-07-01 00:00:00 | 18
2010-07-02 00:00:00 | 14 | 2010-07-02 00:00:00 | 15
2010-07-27 00:00:00 | 13 | 2010-07-27 00:00:00 | 14
2010-07-22 00:00:00 | 8 | 2010-07-22 00:00:00 | 15
2010-07-09 00:00:00 | 9 | 2010-07-22 00:00:00 | 15
2010-07-01 00:00:00 | 8 | 2010-07-07 00:00:00 | 10
2010-07-01 00:00:00 | 11 | 2010-07-02 00:00:00 | 12
2010-07-05 00:00:00 | 8 | 2010-07-07 00:00:00 | 10
2010-07-22 00:00:00 | 15 | 2010-07-29 00:00:00 | 10
2010-07-29 00:00:00 | 8 | 2010-08-02 00:00:00 | 17
2010-07-05 00:00:00 | 13 | 2010-07-06 00:00:00 | 17
2010-07-08 00:00:00 | 15 | 2010-07-15 00:00:00 | 17
2010-07-09 00:00:00 | 13 | 2010-07-20 00:00:00 | 9
2010-07-29 00:00:00 | 9 | 2010-07-30 00:00:00 | 15
2010-07-30 00:00:00 | 12 | 2010-08-02 00:00:00 | 15
2010-07-12 00:00:00 | 9 | 2010-07-13 00:00:00 | 17
2010-07-01 00:00:00 | 13 | 2010-07-01 00:00:00 | 14
2010-07-08 00:00:00 | 9 | 2010-07-19 00:00:00 | 12
2010-07-29 00:00:00 | 10 | 2010-08-06 00:00:00 | 15
2010-07-10 00:00:00 | 8 | 2010-07-19 00:00:00 | 14
2010-07-29 00:00:00 | 9 | 2010-08-04 00:00:00 | 11
2010-07-29 00:00:00 | 16 | 2010-08-13 00:00:00 | 14
2010-07-13 00:00:00 | 8 | 2010-07-15 00:00:00 | 15
2010-07-13 00:00:00 | 8 | 2010-07-23 00:00:00 | 17
2010-07-26 00:00:00 | 8 | 2010-07-29 00:00:00 | 8
2010-07-30 00:00:00 | 12 | 2010-08-06 00:00:00 | 16
2010-07-29 00:00:00 | 15 | 2010-08-03 00:00:00 | 9
2010-07-15 00:00:00 | 9 | 2010-07-20 00:00:00 | 9
2010-07-19 00:00:00 | 9 | 2010-07-19 00:00:00 | 10
2010-07-01 00:00:00 | 12 | 2010-07-05 00:00:00 | 12
2010-07-08 00:00:00 | 9 | 2010-07-13 00:00:00 | 15
2010-07-28 00:00:00 | 9 | 2010-07-28 00:00:00 | 13
2010-07-07 00:00:00 | 9 | 2010-07-07 00:00:00 | 10
2010-07-28 00:00:00 | 9 | 2010-07-28 00:00:00 | 13
2010-07-07 00:00:00 | 13 | 2010-07-08 00:00:00 | 10
2010-07-26 00:00:00 | 9 | 2010-07-28 00:00:00 | 13
2010-07-26 00:00:00 | 8 | 2010-07-26 00:00:00 | 17
2010-07-26 00:00:00 | 11 | 2010-07-26 00:00:00 | 12
2010-07-28 00:00:00 | 8 | 2010-07-28 00:00:00 | 12
2010-07-29 00:00:00 | 8 | 2010-07-29 00:00:00 | 10
2010-07-26 00:00:00 | 11 | 2010-07-26 00:00:00 | 13
2010-07-01 00:00:00 | 13 | 2010-07-01 00:00:00 | 15
2010-07-29 00:00:00 | 13 | 2010-07-29 00:00:00 | 14
2010-07-06 00:00:00 | 16 | 2010-07-07 00:00:00 | 16
2010-07-21 00:00:00 | 16 | 2010-07-26 00:00:00 | 14
2010-07-23 00:00:00 | 13 | 2010-07-29 00:00:00 | 10
2010-07-28 00:00:00 | 11 | 2010-07-28 00:00:00 | 14
2010-07-01 00:00:00 | 8 | 2010-07-01 00:00:00 | 9
2010-07-01 00:00:00 | 8 | 2010-07-06 00:00:00 | 9
2010-07-29 00:00:00 | 11 | 2010-07-30 00:00:00 | 15
2010-07-07 00:00:00 | 9 | 2010-07-09 00:00:00 | 10
2010-07-01 00:00:00 | 10 | 2010-07-01 00:00:00 | 14
2010-07-22 00:00:00 | 8 | 2010-07-22 00:00:00 | 13
2010-07-20 00:00:00 | 14 | 2010-07-20 00:00:00 | 15
2010-07-06 00:00:00 | 10 | 2010-07-06 00:00:00 | 12
2010-07-14 00:00:00 | 8 | 2010-07-14 00:00:00 | 10
2010-07-22 00:00:00 | 12 | 2010-07-28 00:00:00 | 11
2010-07-22 00:00:00 | 8 | 2010-07-27 00:00:00 | 15