Spreadsheet: 725767d1616846580-countif-for-hrs-mins-countif-for-hrs-mins
Sheet: Sheet1

Time |  |  | CountIF
 |  | 00:59:00 |  |  | Note: The data in column 'A' is form a large document. The blanks are where the time is not applicable. I can modifiy this be 00:00 or otherwise.
 |  | 01:59:00
 |  | 02:59:00
 |  | 03:59:00
 |  | 04:59:00
 |  | 05:59:00
 |  | 06:59:00
 |  | 07:59:00
 |  | 08:59:00
 |  | 09:59:00
 |  | 10:59:00
2020-12-21 11:59:00 |  | 11:59:00
 |  | 12:59:00
 |  | 13:59:00
 |  | 14:59:00
 |  | 15:59:00
 |  | 16:59:00
 |  | 17:59:00
 |  | 18:59:00
 |  | 19:59:00
 |  | 20:59:00
 |  | 21:59:00
 |  | 22:59:00
 |  | 23:59:00
2020-12-22 02:59:00
2020-12-22 08:59:00
2020-12-22 11:59:00
2020-12-22 17:59:00
2020-12-22 19:59:00
2020-12-22 23:59:00
2020-12-23 02:59:00
2020-12-23 07:59:00
2020-12-23 20:59:00
2020-12-23 23:59:00
2020-12-24 06:59:00
2020-12-24 08:59:00
2020-12-24 10:59:00
2020-12-24 13:59:00
2020-12-24 17:59:00
2020-12-24 22:59:00
2020-12-25 02:59:00
2020-12-25 05:59:00
2020-12-25 12:59:00
2020-12-28 01:59:00
2020-12-28 05:59:00
2020-12-28 12:59:00
2020-12-28 17:59:00
2020-12-28 22:59:00
2020-12-29 08:59:00
2020-12-29 11:59:00
2020-12-29 15:59:00
2020-12-29 23:59:00
2020-12-30 10:59:00
2020-12-30 14:59:00
2020-12-30 18:59:00
2020-12-30 21:59:00
2020-12-31 04:59:00
2020-12-31 10:59:00
2020-12-31 19:59:00
2020-12-31 23:59:00
2021-01-04 01:59:00
2021-01-04 03:59:00
2021-01-04 06:59:00
2021-01-04 18:59:00
2021-01-04 22:59:00
2021-01-05 05:59:00
2021-01-05 09:59:00
2021-01-05 14:59:00
2021-01-05 23:59:00
2021-01-06 04:59:00
2021-01-06 09:59:00
2021-01-06 16:59:00
2021-01-06 21:59:00
2021-01-06 23:59:00
2021-01-07 12:59:00
2021-01-07 15:59:00
2021-01-07 18:59:00
2021-01-08 02:59:00
2021-01-08 09:59:00
2021-01-08 11:59:00
2021-01-08 13:59:00
2021-01-08 20:59:00
2021-01-11 06:59:00
2021-01-11 08:59:00
2021-01-11 10:59:00
2021-01-11 15:59:00
2021-01-11 23:59:00
2021-01-12 05:59:00
2021-01-12 09:59:00
2021-01-12 12:59:00
2021-01-12 15:59:00
2021-01-12 23:59:00
2021-01-13 06:59:00
2021-01-13 17:59:00
2021-01-13 23:59:00
2021-01-14 01:59:00
2021-01-14 04:59:00
2021-01-14 08:59:00
2021-01-14 15:59:00
2021-01-14 20:59:00
2021-01-15 10:59:00
2021-01-15 16:59:00
2021-01-18 00:59:00
2021-01-18 11:59:00
2021-01-18 13:59:00
2021-01-18 20:59:00
2021-01-18 23:59:00
2021-01-19 07:59:00
2021-01-19 11:59:00
2021-01-19 20:59:00
2021-01-19 23:59:00
2021-01-20 02:59:00
2021-01-20 05:59:00
2021-01-20 10:59:00
2021-01-20 13:59:00
2021-01-20 19:59:00
2021-01-21 09:59:00
2021-01-21 15:59:00
2021-01-21 18:59:00
2021-01-21 22:59:00
2021-01-22 05:59:00
2021-01-22 08:59:00
2021-01-22 14:59:00
2021-01-22 16:59:00
2021-01-22 19:59:00
2021-01-22 22:59:00
2021-01-25 00:59:00
2021-01-25 02:59:00
2021-01-25 04:59:00
2021-01-25 10:59:00
2021-01-25 17:59:00
2021-01-25 21:59:00
2021-01-26 08:59:00
2021-01-26 18:59:00
2021-01-26 23:59:00
2021-01-27 05:59:00
2021-01-27 10:59:00
2021-01-27 17:59:00
2021-01-28 05:59:00
2021-01-28 10:59:00
2021-01-28 13:59:00
2021-01-29 06:59:00
2021-01-29 10:59:00
2021-01-29 13:59:00
2021-01-29 21:59:00
2021-02-01 02:59:00
2021-02-01 16:59:00
2021-02-01 22:59:00
2021-02-02 01:59:00
2021-02-02 08:59:00
2021-02-02 13:59:00
2021-02-02 16:59:00
2021-02-02 19:59:00
2021-02-03 05:59:00
2021-02-03 07:59:00
2021-02-03 10:59:00
2021-02-03 14:59:00
2021-02-03 16:59:00
2021-02-03 23:59:00
2021-02-04 01:59:00
2021-02-04 05:59:00
2021-02-04 12:59:00
2021-02-04 19:59:00
2021-02-04 22:59:00
2021-02-05 04:59:00
2021-02-05 07:59:00
2021-02-05 13:59:00
2021-02-05 20:59:00
2021-02-08 01:59:00
2021-02-08 06:59:00
2021-02-08 12:59:00
2021-02-08 19:59:00
2021-02-08 23:59:00
2021-02-09 05:59:00
2021-02-09 13:59:00
2021-02-09 15:59:00
2021-02-09 17:59:00
2021-02-09 19:59:00
2021-02-09 21:59:00
2021-02-10 03:59:00
2021-02-10 06:59:00
2021-02-10 11:59:00
2021-02-10 13:59:00
2021-02-10 17:59:00
2021-02-10 22:59:00
2021-02-11 02:59:00
2021-02-11 12:59:00
2021-02-11 20:59:00
2021-02-11 22:59:00
2021-02-12 04:59:00
2021-02-12 10:59:00
2021-02-12 12:59:00
2021-02-12 15:59:00
2021-02-12 21:59:00
2021-02-15 00:59:00
2021-02-15 05:59:00
2021-02-15 08:59:00
2021-02-15 11:59:00
2021-02-15 15:59:00
2021-02-15 23:59:00
2021-02-16 08:59:00
2021-02-16 10:59:00
2021-02-16 15:59:00
2021-02-16 18:59:00
2021-02-17 01:59:00
2021-02-17 06:59:00
2021-02-17 08:59:00
2021-02-17 12:59:00
2021-02-17 16:59:00
2021-02-17 20:59:00
2021-02-17 22:59:00
2021-02-18 02:59:00
2021-02-18 05:59:00
2021-02-18 07:59:00
2021-02-18 12:59:00
2021-02-18 17:59:00
2021-02-18 22:59:00
2021-02-19 04:59:00
2021-02-19 16:59:00
2021-02-19 20:59:00
2021-02-22 00:59:00
2021-02-22 05:59:00
2021-02-22 09:59:00
2021-02-23 00:59:00
2021-02-23 04:59:00
2021-02-23 11:59:00
2021-02-23 15:59:00
2021-02-23 18:59:00
2021-02-24 00:59:00
2021-02-24 06:59:00
2021-02-24 11:59:00
2021-02-24 15:59:00
2021-02-24 23:59:00
2021-02-25 03:59:00
2021-02-25 22:59:00
2021-02-26 02:59:00
2021-02-26 08:59:00
2021-02-26 13:59:00
2021-02-26 22:59:00
2021-03-01 00:59:00
2021-03-01 05:59:00
2021-03-01 13:59:00
2021-03-01 23:59:00
2021-03-02 03:59:00
2021-03-02 06:59:00
2021-03-02 09:59:00
2021-03-02 14:59:00
2021-03-02 18:59:00
2021-03-02 23:59:00
2021-03-03 07:59:00
2021-03-03 15:59:00
2021-03-04 00:59:00
2021-03-04 04:59:00
2021-03-04 12:59:00
2021-03-04 15:59:00
2021-03-04 21:59:00
2021-03-05 03:59:00
2021-03-05 05:59:00
2021-03-05 12:59:00
2021-03-05 17:59:00
2021-03-08 00:59:00
2021-03-08 04:59:00
2021-03-08 13:59:00
2021-03-08 17:59:00
2021-03-08 23:59:00
2021-03-09 02:59:00
2021-03-09 07:59:00
2021-03-09 14:59:00
2021-03-09 17:59:00
2021-03-10 06:59:00
2021-03-10 12:59:00
2021-03-10 17:59:00
2021-03-11 01:59:00
2021-03-11 12:59:00
2021-03-11 16:59:00
2021-03-12 00:59:00
2021-03-12 04:59:00
2021-03-12 10:59:00
2021-03-12 12:59:00