Spreadsheet: 865900d1712854647-averaging-time-duration-excel-help-forum-example
Sheet: 2024-04-10 Agent Status Summary

Logged In | On [NAME] | Idle | Not Responding | [NAME] | Available | Busy | Away | Break | Meal | Meeting | Training | Interacting
08:32:08.008 | 07:16:16.276 | 00:28:11.132 |  | 01:15:51.732 | 00:09:41.104 | 00:02:10.029 |  | 00:32:51.869 | 00:31:08.730
08:40:38.728 | 00:34:56.600 | 00:06:17.687 |  | 08:05:42.128 | 01:24:57.600 | 05:36:31.037 |  | 00:31:58.641 | 00:32:14.850
10:15:53.857 | 00:34:17.312 | 00:08:27.821 |  | 09:41:36.545 | 00:06:31.083 | 08:32:58.437 |  | 00:31:24.971 | 00:30:42.054
08:31:41.510 | 07:12:42.519 | 00:27:36.617 |  | 01:18:58.991 | 00:16:20.297 |  |  | 00:31:16.847 | 00:31:21.847
08:28:03.640 | 06:16:09.789 | 00:19:42.562 |  | 02:11:53.851 | 00:48:20.136 |  | 00:14:02.805 | 00:37:58.504 | 00:31:32.406
17:22:30.604 |  |  |  | 17:22:30.604 |  | 15:12:54.991 |  | 00:30:38.786 | 00:30:31.198 | 01:08:25.629
08:24:53.280 | 06:32:10.985 | 00:11:17.678 |  | 01:52:42.295 | 00:30:11.606 |  |  | 00:43:21.422 | 00:39:09.267 |  |  | 06:21:11
08:07:21.872 | 06:36:06.641 | 00:38:10.356 |  | 01:31:15.231 | 00:17:07.183 |  | 00:05:35.726 | 00:35:25.219 | 00:33:07.103
08:25:16.444 | 06:57:02.170 | 00:21:55.872 |  | 01:28:14.274 | 00:05:58.138 | 00:02:50.704 | 00:07:12.594 | 00:35:38.333 | 00:36:34.505
08:27:40.934 | 07:15:06.522 | 00:38:23.785 | 00:01:18.619 | 01:12:34.412 | 00:08:28.833 |  |  | 00:33:17.759 | 00:30:47.820
08:11:56.979 |  |  |  | 08:11:56.979 | 01:27:49.686 | 05:40:35.647 |  | 00:39:29.787 | 00:24:01.859
07:49:20.863 | 05:49:39.961 | 00:21:38.858 |  | 01:59:40.902 | 00:47:44.826 |  | 00:08:16.194 | 00:31:31.223 | 00:32:08.659 |  |  | 06:16:10
06:02:28.707 | 04:31:00.523 | 00:35:00.983 |  | 01:31:28.184 | 00:22:51.800 |  | 00:08:38.407 | 00:29:44.463 | 00:30:13.514 |  |  | 04:10:18
09:10:02.844 | 00:26:02.595 | 00:02:29.165 |  | 08:44:00.249 | 00:09:12.341 | 07:33:01.644 |  | 00:31:05.055 | 00:30:41.209 |  |  | 00:58:05
08:32:09.672 | 07:26:27.839 | 00:25:08.584 |  | 01:05:41.833 | 00:04:50.773 |  |  | 00:30:37.213 | 00:30:13.847 |  |  | 07:01:26
08:32:13.481 | 07:18:32.702 | 00:33:04.316 |  | 01:13:40.779 | 00:07:46.820 |  |  | 00:30:43.994 | 00:35:09.965 |  |  | 06:45:48
08:36:49.922 | 07:09:39.556 | 00:14:16.678 |  | 01:27:10.366 | 00:00:07.377 |  | 00:14:51.766 | 00:41:02.663 | 00:31:08.560 |  |  | 07:10:20
08:39:51.388 | 00:27:05.917 | 00:03:33.197 |  | 08:12:45.471 | 00:12:01.889 | 06:05:34.680 |  | 00:15:27.837 | 00:30:17.083 | 01:09:23.982 |  | 00:23:38
08:21:44.109 | 06:10:09.289 | 00:04:45.472 | 00:00:11.051 | 02:11:34.820 | 00:42:19.919 |  |  | 00:53:52.819 | 00:35:22.082 |  |  | 06:29:34
08:41:35.392 | 06:12:01.039 | 00:15:38.435 | 00:00:02.545 | 02:29:34.353 | 01:25:41.532 | 00:05:58.627 |  | 00:30:18.326 | 00:27:35.868 |  |  | 06:07:49
08:30:56.158 | 06:28:53.227 | 00:21:08.386 |  | 02:02:02.931 | 00:29:41.511 |  | 00:29:07.456 | 00:32:47.604 | 00:30:26.360 |  |  | 06:20:38
08:20:21.071 |  |  |  | 08:20:21.071 | 07:07:06.400
08:26:18.558 | 07:18:47.796 | 00:24:20.580 |  | 01:07:30.762 | 00:02:47.182 |  |  | 00:34:32.613 | 00:30:10.967 |  |  | [NAME]
08:29:43.154 | 06:35:10.591 | 00:41:05.384 |  | 01:54:32.563 | 00:16:26.028 | 00:04:00.791 | 00:25:24.914 | 00:30:29.944 | 00:30:09.891 | 00:08:00.995 |  | 06:01:34
06:51:13.173 | 00:27:06.018 | 00:00:42.235 |  | 06:24:07.155 | 00:21:10.512 | 06:02:56.643 |  |  |  |  |  | 00:26:23
08:39:08.152 | 07:30:17.025 | 00:27:24.384 |  | 01:08:51.127 | 00:10:13.068 |  |  | 00:29:03.796 | 00:29:34.263 |  |  | 07:06:08
08:48:07.250 | 07:20:15.484 | 00:24:25.485 |  | 01:27:51.766 | 00:07:35.454 |  | 00:15:59.566 | 00:32:44.862 | 00:31:31.884 |  |  | 07:04:51
08:41:04.451 | 00:32:42.601 | 00:05:34.717 |  | 08:08:21.850 | 00:04:38.685 | 07:01:48.197 |  | 00:29:57.398 | 00:31:57.570 |  |  | 00:31:33
08:31:43.074 | 06:42:58.977 | 00:27:27.295 |  | 01:48:44.097 | 00:00:20.572 |  | 00:31:42.541 | 00:34:48.245 | 00:32:00.081 | 00:09:52.658 |  | 06:15:56
08:30:21.966 | 05:28:39.576 | 00:02:30.307 |  | 03:01:42.390 | 00:03:15.469 |  | 00:29:07.064 | 00:33:14.369 | 00:34:50.034 | 01:21:15.454 |  | 05:34:53
08:44:52.302 | 07:31:06.064 | 00:30:56.355 |  | 01:13:46.238 | 00:09:28.824 |  |  | 00:32:13.594 | 00:32:03.820 |  |  | 08:03:54
08:32:47.270 |  |  |  | 08:32:47.270 | 00:00:50.986 | 06:25:38.677 |  | 01:34:53.714 | 00:31:23.893
06:57:51.133 | 05:31:36.704 | [NAME] |  | 01:26:14.429 | 00:02:51.951 | 00:13:39.329 | 00:15:44.700 | 00:21:15.898 | 00:32:42.551 |  |  | 05:11:26
09:01:40.237 | 07:24:01.941 | 00:17:31.193 |  | 01:37:38.296 | 00:33:14.608 |  |  | 00:32:25.113 | 00:31:58.575 |  |  | 07:06:55
08:45:31.752 | 00:30:52.900 | 00:03:35.893 |  | 08:14:38.852 | 00:01:06.159 | 07:23:36.321 |  | 00:15:13.472 | 00:34:42.900 |  |  | 00:27:34
07:48:47.385 | 00:33:34.251 | 00:03:18.018 |  | 07:15:13.134 | 00:09:03.004 | 06:04:25.200 |  | 00:31:07.677 | 00:30:37.253 |  |  | 00:32:41
08:33:58.514 | 06:57:37.060 | 00:20:16.585 |  | 01:36:21.454 | 00:12:46.653 |  | 00:18:47.080 | 00:32:54.713 | 00:31:53.008 |  |  | 06:38:56
08:29:47.173 | 06:58:52.409 | 00:26:27.006 | 00:00:12.720 | 01:30:54.764 | 00:09:48.357 | 00:12:10.430 | 00:04:25.167 | 00:32:57.976 | 00:31:32.834 |  |  | 06:46:46
23:45:13.413 |  |  |  | 23:45:13.413 | 23:45:13.413