Spreadsheet: 809335d1671035903-time-averages-not-calculating-properly-time-averages-not-calculating-properly-1-
Sheet: Start 08012022

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