Spreadsheet: 809327d1671032490-time-averages-not-calculating-properly-time-averages-not-calculating-properly
Sheet: Start 08012022

 |  |  | END OF DAY
 |  |  | PATIENT RECALL SUPPORT
 |  |  |  |  |  | ASA
 | Offered | Answered | SL% | AB% | AVG TALK TIME | AVD SPEED OF
 |  |  |  |  |  | ANSWER
 | Offered | Answered | SL% | AB% | AVG TALK TIME | ASA
2022-10-31 00:00:00 | 1735 | 720 | 0.02 | 0.55 | 09:59:00 | 1.393055555555555
2022-11-01 00:00:00 | 1344 | 648 | 0 | 0.49 | 11:12:00 | 1.107638888888889
2022-11-02 00:00:00 | 1279 | 727 | 0.01 | 0.39 | 10:04:00 | 0.7020833333333334
2022-11-03 00:00:00 | 1173 | 777 | 0.07 | 0.3 | 09:44:00 | 0.475
2022-11-04 00:00:00 | 1081 | 693 | 0.19 | 0.34 | 09:47:00 | 0.5479166666666667
2022-11-07 00:00:00 | 1874 | 707 | 0.01 | 0.58 | 10:04:00 | 1.504861111111111
2022-11-08 00:00:00 | 1286 | 636 | 0.04 | 0.48 | 09:47:00 | 0.9562499999999999
2022-11-09 00:00:00 | 1137 | 606 | 0.01 | 0.43 | 10:35:00 | 0.8590277777777778
2022-11-10 00:00:00 | 1043 | 666 | 0 | 0.34 | 09:34:00 | 0.6666666666666666
2022-11-11 00:00:00 | Veterans Day
2022-11-14 00:00:00 | 1800 | 745 | 0 | 0.56 | 09:53:00 | 1.354166666666667
2022-11-15 00:00:00 | 1302 | 685 | 0.06 | 0.42 | 10:12:00 | 1.029861111111111
2022-11-16 00:00:00 | 1057 | 762 | 0.32 | 0.26 | 09:17:00 | 0.4694444444444445
2022-11-17 00:00:00 | 1038 | 709 | 0.07 | 0.28 | 09:47:00 | 0.4979166666666666
2022-11-18 00:00:00 | 945 | 650 | 0.25 | 0.29 | 09:32:00 | 0.5201388888888888
2022-11-21 00:00:00 | 1333 | 664 | 0 | 0.47 | 10:52:00 | 1.159722222222222
2022-11-22 00:00:00 | 958 | 673 | 0.12 | 0.29 | 09:41:00 | 0.5208333333333334
2022-11-23 00:00:00 | 885 | 739 | 0.32 | 0.16 | 09:33:00 | 0.2125
2022-11-24 00:00:00 | Thanksgiving Day
2022-11-25 00:00:00 | Day After Thanksgiving
2022-11-28 00:00:00 | 1546 | 747 | 0.01 | 0.48 | 09:56:00 | 1.143055555555555
2022-11-29 00:00:00 | 1202 | 606 | 0.01 | 0.41 | 10:52:00 | 0.8590277777777778
2022-11-30 00:00:00 | 1147 | 669 | 0.08 | 0.38 | 09:58:00 | 0.6749999999999999
2022-12-01 00:00:00 | 1124 | 673 | 0.06 | 0.37 | 10:06:00 | 0.63125
2022-12-02 00:00:00 | 1212 | 657 | 0.14 | 0.4 | 09:53:00 | 0.6590277777777778
2022-12-05 00:00:00 | 1613 | 636 | 0 | 0.56 | 10:20:00 | 1.304861111111111
2022-12-06 00:00:00 | 1442 | 611 | 0.02 | 0.54 | 09:59:00 | 1.332638888888889
2022-12-07 00:00:00 | 1291 | 730 | 0.01 | 0.4 | 08:52:00 | 0.7784722222222222
2022-12-08 00:00:00 | 1169 | 643 | 0.1 | 0.43 | 09:00:00 | 0.81875
2022-12-09 00:00:00 | 1174 | 577 | 0.19 | 0.45 | 09:10:00 | 0.8201388888888889
average
manual |  |  |  |  | 09:54:00
 |  |  |  |  |  | 1900-01-20 05:45:36
 |  |  |  |  |  |  |  | average
 |  |  |  |  |  |  | manual entry with decimals
 |  |  |  |  |  | 1 day, 9:26:00 | 33.26
 |  |  |  |  |  | 1 day, 2:35:00 | 26.35
 |  |  |  |  |  | 16:51:00 | 16.51
 |  |  |  |  |  | 11:24:00 | 11.24
 |  |  |  |  |  | 13:09:00 | 13.09
 |  |  |  |  |  | 1 day, 12:07:00 | 36.07
 |  |  |  |  |  | 22:57:00 | 22.57
 |  |  |  |  |  | 20:37:00 | 20.37
 |  |  |  |  |  | 16:00:00 | 16
 |  |  |  |  |  | 1 day, 8:30:00 | 32.3
 |  |  |  |  |  | 1 day, 0:43:00 | 24.43
 |  |  |  |  |  | 11:16:00 | 11.16
 |  |  |  |  |  | 11:57:00 | 11.57
 |  |  |  |  |  | 12:29:00 | 12.29
 |  |  |  |  |  | 1 day, 3:50:00 | 27.5
 |  |  |  |  |  | 12:30:00 | 12.3
 |  |  |  |  |  | 05:06:00 | 5.06
 |  |  |  |  |  | 1 day, 3:26:00 | 27.26
 |  |  |  |  |  | 20:37:00 | 20.37
 |  |  |  |  |  | 16:12:00 | 16.12
 |  |  |  |  |  | 15:09:00 | 15.09
 |  |  |  |  |  | 15:49:00 | 15.49
 |  |  |  |  |  | 1 day, 7:19:00 | 31.19
 |  |  |  |  |  | 1 day, 7:59:00 | 31.59
 |  |  |  |  |  | 18:41:00 | 18.41
 |  |  |  |  |  | 19:39:00 | 19.39
 |  |  |  |  |  | 19:41:00 | 19.41