Sum formula required to total hh:mm:ss

[WendyHubard]

Hello,
I have multiple spreadsheets and I'm trying to total columns that contain time duration in the format of hh:mm:ss (sample below). Have the column format set to hh:mm:ss but it's just not working. Have also tried "text to columns" and removed all delimiters.
Any help greatly appreciated. Thanks in advance

	09:53:00​
	05:59:00​
	10:00:00​
	10:00:00​
	10:00:00​
	05:50:00​
	09:58:00​
	00:05:00​
	06:21:00​
total using Sum	20:06:00​

 

[Dave Patton]

Delete the contents of B11:D11
set format as General and then Format Cells custom format [h]:mm:ss

Dates Time.xlsm
	A	B
1
2		09:53:00
3		05:59:00
4		10:00:00
5		10:00:00
6		10:00:00
7		05:50:00
8		09:58:00
9		00:05:00
10		06:21:00
11	total using Sum	68:06:00
4a

Cell Formulas
Range	Formula
B11	B11	=SUMPRODUCT(--(LEFT(B2:B10,5)))

Dates Time.xlsm
	A	B	C	D
1
2		09:53:00	09:53:00	09:53:00
3		05:59:00	05:59:00	05:59:00
4		10:00:00	10:00:00	10:00:00
5		10:00:00	10:00:00	10:00:00
6		10:00:00	10:00:00	10:00:00
7		05:50:00	05:50:00	05:50:00
8		09:58:00	09:58:00	09:58:00
9		00:05:00	00:05:00	00:05:00
10		06:21:00	06:21:00	06:21:00
11	total using Sum	68:06:00	68:06:00	68:06:00
4a

Cell Formulas
Range	Formula
C2:C10	C2	=--LEFT(B2,5)
D2:D10	D2	=--LEFT(B2,8)
B11	B11	=SUMPRODUCT(--LEFT(B2:B10,5))
C11:D11	C11	=SUM(C2:C10)

 

[WendyHubard]

Thanks Dave, I'm struggling to get it to work. I think the duration total should be around 6hours, 34minutes & 2 seconds. Am I able to upload a sample spreadsheet?

Date	Duration
21/07/2023 17:28​	09:53​
21/07/2023 19:33​	05:59​
22/07/2023 8:32​	10:00​
22/07/2023 14:34​	10:00​
22/07/2023 15:01​	10:00​
23/07/2023 8:17​	05:50​
23/07/2023 8:35​	09:58​
23/07/2023 15:26​	00:05​
23/07/2023 15:27​	06:21​
23/07/2023 17:22​	00:05​
23/07/2023 17:53​	00:04​
23/07/2023 17:58​	00:05​
23/07/2023 17:58​	00:06​
23/07/2023 18:03​	06:07​
23/07/2023 18:23​	06:31​
23/07/2023 18:45​	10:00​
24/07/2023 8:19​	04:42​
24/07/2023 10:03​	06:58​
24/07/2023 12:39​	02:17​
24/07/2023 13:34​	00:03​
24/07/2023 13:35​	00:08​
24/07/2023 13:35​	00:05​
24/07/2023 16:24​	01:28​
24/07/2023 16:44​	00:03​
24/07/2023 17:09​	03:11​
24/07/2023 18:38​	00:04​
24/07/2023 18:38​	04:11​
24/07/2023 19:20​	10:00​
25/07/2023 9:10​	01:24​
25/07/2023 11:25​	01:05​
25/07/2023 12:10​	09:20​
25/07/2023 12:30​	03:32​
25/07/2023 14:46​	02:16​
25/07/2023 16:30​	08:51​
25/07/2023 18:13​	00:04​
25/07/2023 18:21​	00:03​
26/07/2023 7:17​	10:00​
26/07/2023 9:54​	08:34​
26/07/2023 11:34​	04:37​
26/07/2023 12:09​	02:38​
26/07/2023 16:58​	06:57​
27/07/2023 7:04​	03:16​
27/07/2023 7:57​	02:52​
27/07/2023 8:10​	01:07​
27/07/2023 9:30​	02:52​
27/07/2023 10:38​	03:45​
27/07/2023 11:52​	00:53​
27/07/2023 12:09​	01:31​
27/07/2023 12:21​	03:10​
27/07/2023 14:08​	01:18​
27/07/2023 16:50​	00:04​
27/07/2023 16:54​	00:02​
27/07/2023 16:54​	10:00​
27/07/2023 18:00​	10:00​
28/07/2023 7:29​	08:48​
28/07/2023 13:59​	07:30​
28/07/2023 16:45​	10:00​
29/07/2023 8:28​	08:08​
29/07/2023 9:11​	06:41​
29/07/2023 16:30​	07:14​
29/07/2023 17:24​	00:03​
29/07/2023 18:09​	04:33​
30/07/2023 9:16​	06:03​
30/07/2023 11:23​	02:12​
30/07/2023 11:36​	02:14​
30/07/2023 12:02​	01:57​
30/07/2023 12:51​	02:03​
30/07/2023 14:03​	10:00​
30/07/2023 16:43​	02:19​
30/07/2023 18:20​	04:26​
31/07/2023 7:54​	01:01​
31/07/2023 9:43​	00:03​
31/07/2023 9:44​	01:44​
31/07/2023 11:49​	01:49​
31/07/2023 15:26​	01:31​
31/07/2023 15:44​	00:04​
31/07/2023 15:55​	03:06​
31/07/2023 16:08​	03:20​
1/08/2023 8:19​	02:15​
1/08/2023 8:32​	02:33​
1/08/2023 9:13​	01:29​
1/08/2023 10:49​	01:46​
1/08/2023 17:19​	09:55​
1/08/2023 18:20​	10:00​
2/08/2023 7:24​	06:57​
2/08/2023 11:15​	10:00​
2/08/2023 13:36​	07:41​
2/08/2023 16:40​	00:03​
3/08/2023 7:02​	10:00​
3/08/2023 7:42​	00:57​
3/08/2023 12:40​	03:15​
3/08/2023 13:24​	01:49​
3/08/2023 14:26​	01:32​
4/08/2023 11:33​	07:35​

 

[Herakles]

Thanks Dave, I'm struggling to get it to work. I think the duration total should be around 6hours, 34minutes & 2 seconds. Am I able to upload a sample spreadsheet?

Date	Duration
21/07/2023 17:28​	09:53​
21/07/2023 19:33​	05:59​
22/07/2023 8:32​	10:00​
22/07/2023 14:34​	10:00​
22/07/2023 15:01​	10:00​
23/07/2023 8:17​	05:50​
23/07/2023 8:35​	09:58​
23/07/2023 15:26​	00:05​
23/07/2023 15:27​	06:21​
23/07/2023 17:22​	00:05​
23/07/2023 17:53​	00:04​
23/07/2023 17:58​	00:05​
23/07/2023 17:58​	00:06​
23/07/2023 18:03​	06:07​
23/07/2023 18:23​	06:31​
23/07/2023 18:45​	10:00​
24/07/2023 8:19​	04:42​
24/07/2023 10:03​	06:58​
24/07/2023 12:39​	02:17​
24/07/2023 13:34​	00:03​
24/07/2023 13:35​	00:08​
24/07/2023 13:35​	00:05​
24/07/2023 16:24​	01:28​
24/07/2023 16:44​	00:03​
24/07/2023 17:09​	03:11​
24/07/2023 18:38​	00:04​
24/07/2023 18:38​	04:11​
24/07/2023 19:20​	10:00​
25/07/2023 9:10​	01:24​
25/07/2023 11:25​	01:05​
25/07/2023 12:10​	09:20​
25/07/2023 12:30​	03:32​
25/07/2023 14:46​	02:16​
25/07/2023 16:30​	08:51​
25/07/2023 18:13​	00:04​
25/07/2023 18:21​	00:03​
26/07/2023 7:17​	10:00​
26/07/2023 9:54​	08:34​
26/07/2023 11:34​	04:37​
26/07/2023 12:09​	02:38​
26/07/2023 16:58​	06:57​
27/07/2023 7:04​	03:16​
27/07/2023 7:57​	02:52​
27/07/2023 8:10​	01:07​
27/07/2023 9:30​	02:52​
27/07/2023 10:38​	03:45​
27/07/2023 11:52​	00:53​
27/07/2023 12:09​	01:31​
27/07/2023 12:21​	03:10​
27/07/2023 14:08​	01:18​
27/07/2023 16:50​	00:04​
27/07/2023 16:54​	00:02​
27/07/2023 16:54​	10:00​
27/07/2023 18:00​	10:00​
28/07/2023 7:29​	08:48​
28/07/2023 13:59​	07:30​
28/07/2023 16:45​	10:00​
29/07/2023 8:28​	08:08​
29/07/2023 9:11​	06:41​
29/07/2023 16:30​	07:14​
29/07/2023 17:24​	00:03​
29/07/2023 18:09​	04:33​
30/07/2023 9:16​	06:03​
30/07/2023 11:23​	02:12​
30/07/2023 11:36​	02:14​
30/07/2023 12:02​	01:57​
30/07/2023 12:51​	02:03​
30/07/2023 14:03​	10:00​
30/07/2023 16:43​	02:19​
30/07/2023 18:20​	04:26​
31/07/2023 7:54​	01:01​
31/07/2023 9:43​	00:03​
31/07/2023 9:44​	01:44​
31/07/2023 11:49​	01:49​
31/07/2023 15:26​	01:31​
31/07/2023 15:44​	00:04​
31/07/2023 15:55​	03:06​
31/07/2023 16:08​	03:20​
1/08/2023 8:19​	02:15​
1/08/2023 8:32​	02:33​
1/08/2023 9:13​	01:29​
1/08/2023 10:49​	01:46​
1/08/2023 17:19​	09:55​
1/08/2023 18:20​	10:00​
2/08/2023 7:24​	06:57​
2/08/2023 11:15​	10:00​
2/08/2023 13:36​	07:41​
2/08/2023 16:40​	00:03​
3/08/2023 7:02​	10:00​
3/08/2023 7:42​	00:57​
3/08/2023 12:40​	03:15​
3/08/2023 13:24​	01:49​
3/08/2023 14:26​	01:32​
4/08/2023 11:33​	07:35​

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[WendyHubard]

Thank you... Think i have downloaded he add-in ok

Test sample for duration.xlsx
	B	C
1	Date	Duration
2	21/07/2023 17:28	09:53
3	21/07/2023 19:33	05:59
4	22/07/2023 8:32	10:00
5	22/07/2023 14:34	10:00
6	22/07/2023 15:01	10:00
7	23/07/2023 8:17	05:50
8	23/07/2023 8:35	09:58
9	23/07/2023 15:26	00:05
10	23/07/2023 15:27	06:21
11	23/07/2023 17:22	00:05
12	23/07/2023 17:53	00:04
13	23/07/2023 17:58	00:05
14	23/07/2023 17:58	00:06
15	23/07/2023 18:03	06:07
16	23/07/2023 18:23	06:31
17	23/07/2023 18:45	10:00
18	24/07/2023 8:19	04:42
19	24/07/2023 10:03	06:58
20	24/07/2023 12:39	02:17
21	24/07/2023 13:34	00:03
22	24/07/2023 13:35	00:08
23	24/07/2023 13:35	00:05
24	24/07/2023 16:24	01:28
25	24/07/2023 16:44	00:03
26	24/07/2023 17:09	03:11
27	24/07/2023 18:38	00:04
28	24/07/2023 18:38	04:11
29	24/07/2023 19:20	10:00
30	25/07/2023 9:10	01:24
31	25/07/2023 11:25	01:05
32	25/07/2023 12:10	09:20
33	25/07/2023 12:30	03:32
34	25/07/2023 14:46	02:16
35	25/07/2023 16:30	08:51
36	25/07/2023 18:13	00:04
37	25/07/2023 18:21	00:03
38	26/07/2023 7:17	10:00
39	26/07/2023 9:54	08:34
40	26/07/2023 11:34	04:37
41	26/07/2023 12:09	02:38
42	26/07/2023 16:58	06:57
43	27/07/2023 7:04	03:16
44	27/07/2023 7:57	02:52
45	27/07/2023 8:10	01:07
46	27/07/2023 9:30	02:52
47	27/07/2023 10:38	03:45
48	27/07/2023 11:52	00:53
49	27/07/2023 12:09	01:31
50	27/07/2023 12:21	03:10
51	27/07/2023 14:08	01:18
52	27/07/2023 16:50	00:04
53	27/07/2023 16:54	00:02
54	27/07/2023 16:54	10:00
55	27/07/2023 18:00	10:00
56	28/07/2023 7:29	08:48
57	28/07/2023 13:59	07:30
58	28/07/2023 16:45	10:00
59	29/07/2023 8:28	08:08
60	29/07/2023 9:11	06:41
61	29/07/2023 16:30	07:14
62	29/07/2023 17:24	00:03
63	29/07/2023 18:09	04:33
64	30/07/2023 9:16	06:03
65	30/07/2023 11:23	02:12
66	30/07/2023 11:36	02:14
67	30/07/2023 12:02	01:57
68	30/07/2023 12:51	02:03
69	30/07/2023 14:03	10:00
70	30/07/2023 16:43	02:19
71	30/07/2023 18:20	04:26
72	31/07/2023 7:54	01:01
73	31/07/2023 9:43	00:03
74	31/07/2023 9:44	01:44
75	31/07/2023 11:49	01:49
76	31/07/2023 15:26	01:31
77	31/07/2023 15:44	00:04
78	31/07/2023 15:55	03:06
79	31/07/2023 16:08	03:20
80	1/08/2023 8:19	02:15
81	1/08/2023 8:32	02:33
82	1/08/2023 9:13	01:29
83	1/08/2023 10:49	01:46
84	1/08/2023 17:19	09:55
85	1/08/2023 18:20	10:00
86	2/08/2023 7:24	06:57
87	2/08/2023 11:15	10:00
88	2/08/2023 13:36	07:41
89	2/08/2023 16:40	00:03
90	3/08/2023 7:02	10:00
91	3/08/2023 7:42	00:57
92	3/08/2023 12:40	03:15
93	3/08/2023 13:24	01:49
94	3/08/2023 14:26	01:32
95	4/08/2023 11:33	07:35
Recorded Calls (2)

 

[Herakles]

Thank you... Think i have downloaded he add-in ok

Test sample for duration.xlsx
	B	C
1	Date	Duration
2	21/07/2023 17:28	09:53
3	21/07/2023 19:33	05:59
4	22/07/2023 8:32	10:00
5	22/07/2023 14:34	10:00
6	22/07/2023 15:01	10:00
7	23/07/2023 8:17	05:50
8	23/07/2023 8:35	09:58
9	23/07/2023 15:26	00:05
10	23/07/2023 15:27	06:21
11	23/07/2023 17:22	00:05
12	23/07/2023 17:53	00:04
13	23/07/2023 17:58	00:05
14	23/07/2023 17:58	00:06
15	23/07/2023 18:03	06:07
16	23/07/2023 18:23	06:31
17	23/07/2023 18:45	10:00
18	24/07/2023 8:19	04:42
19	24/07/2023 10:03	06:58
20	24/07/2023 12:39	02:17
21	24/07/2023 13:34	00:03
22	24/07/2023 13:35	00:08
23	24/07/2023 13:35	00:05
24	24/07/2023 16:24	01:28
25	24/07/2023 16:44	00:03
26	24/07/2023 17:09	03:11
27	24/07/2023 18:38	00:04
28	24/07/2023 18:38	04:11
29	24/07/2023 19:20	10:00
30	25/07/2023 9:10	01:24
31	25/07/2023 11:25	01:05
32	25/07/2023 12:10	09:20
33	25/07/2023 12:30	03:32
34	25/07/2023 14:46	02:16
35	25/07/2023 16:30	08:51
36	25/07/2023 18:13	00:04
37	25/07/2023 18:21	00:03
38	26/07/2023 7:17	10:00
39	26/07/2023 9:54	08:34
40	26/07/2023 11:34	04:37
41	26/07/2023 12:09	02:38
42	26/07/2023 16:58	06:57
43	27/07/2023 7:04	03:16
44	27/07/2023 7:57	02:52
45	27/07/2023 8:10	01:07
46	27/07/2023 9:30	02:52
47	27/07/2023 10:38	03:45
48	27/07/2023 11:52	00:53
49	27/07/2023 12:09	01:31
50	27/07/2023 12:21	03:10
51	27/07/2023 14:08	01:18
52	27/07/2023 16:50	00:04
53	27/07/2023 16:54	00:02
54	27/07/2023 16:54	10:00
55	27/07/2023 18:00	10:00
56	28/07/2023 7:29	08:48
57	28/07/2023 13:59	07:30
58	28/07/2023 16:45	10:00
59	29/07/2023 8:28	08:08
60	29/07/2023 9:11	06:41
61	29/07/2023 16:30	07:14
62	29/07/2023 17:24	00:03
63	29/07/2023 18:09	04:33
64	30/07/2023 9:16	06:03
65	30/07/2023 11:23	02:12
66	30/07/2023 11:36	02:14
67	30/07/2023 12:02	01:57
68	30/07/2023 12:51	02:03
69	30/07/2023 14:03	10:00
70	30/07/2023 16:43	02:19
71	30/07/2023 18:20	04:26
72	31/07/2023 7:54	01:01
73	31/07/2023 9:43	00:03
74	31/07/2023 9:44	01:44
75	31/07/2023 11:49	01:49
76	31/07/2023 15:26	01:31
77	31/07/2023 15:44	00:04
78	31/07/2023 15:55	03:06
79	31/07/2023 16:08	03:20
80	1/08/2023 8:19	02:15
81	1/08/2023 8:32	02:33
82	1/08/2023 9:13	01:29
83	1/08/2023 10:49	01:46
84	1/08/2023 17:19	09:55
85	1/08/2023 18:20	10:00
86	2/08/2023 7:24	06:57
87	2/08/2023 11:15	10:00
88	2/08/2023 13:36	07:41
89	2/08/2023 16:40	00:03
90	3/08/2023 7:02	10:00
91	3/08/2023 7:42	00:57
92	3/08/2023 12:40	03:15
93	3/08/2023 13:24	01:49
94	3/08/2023 14:26	01:32
95	4/08/2023 11:33	07:35
Recorded Calls (2)

Take the value in cell C2.

This, I assume this should be 9 minutes and 53 seconds but is coming out as 0.411805555555556 which is 9 hours and 53 minutes.

Times are stored as decimals, .5 being midday and .25 being 6AM.

Can you change the format to HH:MM:SS or show the value as a number to see what I mean.

 

[Dave Patton]

The time is showing as hours and minutes.
You may want the numbers to be minutes and seconds

=SUM(C2:C95/60)

Dates Time.xlsm
	B	C	D
94	3-Aug-23 14:26:00	01:32:00	00:01:32
95	4-Aug-23 11:33:00	07:35:00	00:07:35
96		399:01:00	6:39:01
97
4aa

Cell Formulas
Range	Formula
D94:D95	D94	=C94/60
C96:D96	C96	=SUM(C2:C95)

 

[WendyHubard]

Thank you. I have reformatted the DURATION column to HH:MM:SS - but still can't get the sum formula to work properly

Test sample for duration.xlsx
	B	C
1	Date	Duration
2	21/07/2023 17:28	09:53:00
3	21/07/2023 19:33	05:59:00
4	22/07/2023 8:32	10:00:00
5	22/07/2023 14:34	10:00:00
6	22/07/2023 15:01	10:00:00
7	23/07/2023 8:17	05:50:00
8	23/07/2023 8:35	09:58:00
9	23/07/2023 15:26	00:05:00
10	23/07/2023 15:27	06:21:00
11	23/07/2023 17:22	00:05:00
12	23/07/2023 17:53	00:04:00
13	23/07/2023 17:58	00:05:00
14	23/07/2023 17:58	00:06:00
15	23/07/2023 18:03	06:07:00
16	23/07/2023 18:23	06:31:00
17	23/07/2023 18:45	10:00:00
18	24/07/2023 8:19	04:42:00
19	24/07/2023 10:03	06:58:00
20	24/07/2023 12:39	02:17:00
21	24/07/2023 13:34	00:03:00
22	24/07/2023 13:35	00:08:00
23	24/07/2023 13:35	00:05:00
24	24/07/2023 16:24	01:28:00
25	24/07/2023 16:44	00:03:00
26	24/07/2023 17:09	03:11:00
27	24/07/2023 18:38	00:04:00
28	24/07/2023 18:38	04:11:00
29	24/07/2023 19:20	10:00:00
30	25/07/2023 9:10	01:24:00
31	25/07/2023 11:25	01:05:00
32	25/07/2023 12:10	09:20:00
33	25/07/2023 12:30	03:32:00
34	25/07/2023 14:46	02:16:00
35	25/07/2023 16:30	08:51:00
36	25/07/2023 18:13	00:04:00
37	25/07/2023 18:21	00:03:00
38	26/07/2023 7:17	10:00:00
39	26/07/2023 9:54	08:34:00
40	26/07/2023 11:34	04:37:00
41	26/07/2023 12:09	02:38:00
42	26/07/2023 16:58	06:57:00
43	27/07/2023 7:04	03:16:00
44	27/07/2023 7:57	02:52:00
45	27/07/2023 8:10	01:07:00
46	27/07/2023 9:30	02:52:00
47	27/07/2023 10:38	03:45:00
48	27/07/2023 11:52	00:53:00
49	27/07/2023 12:09	01:31:00
50	27/07/2023 12:21	03:10:00
51	27/07/2023 14:08	01:18:00
52	27/07/2023 16:50	00:04:00
53	27/07/2023 16:54	00:02:00
54	27/07/2023 16:54	10:00:00
55	27/07/2023 18:00	10:00:00
56	28/07/2023 7:29	08:48:00
57	28/07/2023 13:59	07:30:00
58	28/07/2023 16:45	10:00:00
59	29/07/2023 8:28	08:08:00
60	29/07/2023 9:11	06:41:00
61	29/07/2023 16:30	07:14:00
62	29/07/2023 17:24	00:03:00
63	29/07/2023 18:09	04:33:00
64	30/07/2023 9:16	06:03:00
65	30/07/2023 11:23	02:12:00
66	30/07/2023 11:36	02:14:00
67	30/07/2023 12:02	01:57:00
68	30/07/2023 12:51	02:03:00
69	30/07/2023 14:03	10:00:00
70	30/07/2023 16:43	02:19:00
71	30/07/2023 18:20	04:26:00
72	31/07/2023 7:54	01:01:00
73	31/07/2023 9:43	00:03:00
74	31/07/2023 9:44	01:44:00
75	31/07/2023 11:49	01:49:00
76	31/07/2023 15:26	01:31:00
77	31/07/2023 15:44	00:04:00
78	31/07/2023 15:55	03:06:00
79	31/07/2023 16:08	03:20:00
80	1/08/2023 8:19	02:15:00
81	1/08/2023 8:32	02:33:00
82	1/08/2023 9:13	01:29:00
83	1/08/2023 10:49	01:46:00
84	1/08/2023 17:19	09:55:00
85	1/08/2023 18:20	10:00:00
86	2/08/2023 7:24	06:57:00
87	2/08/2023 11:15	10:00:00
88	2/08/2023 13:36	07:41:00
89	2/08/2023 16:40	00:03:00
90	3/08/2023 7:02	10:00:00
91	3/08/2023 7:42	00:57:00
92	3/08/2023 12:40	03:15:00
93	3/08/2023 13:24	01:49:00
94	3/08/2023 14:26	01:32:00
95	4/08/2023 11:33	07:35:00
Recorded Calls (2)

 

[Dave Patton]

Dates Time.xlsm
	B	C	D
1	Date	Duration
2	21-Jul-23 17:28:00	09:53:00	00:09:53
3	21-Jul-23 19:33:00	05:59:00	00:05:59
4	22-Jul-23 8:32:00	10:00:00	00:10:00
5	22-Jul-23 14:34:00	10:00:00	00:10:00
6	22-Jul-23 15:01:00	10:00:00	00:10:00
7	23-Jul-23 8:17:00	05:50:00	00:05:50
8	23-Jul-23 8:35:00	09:58:00	00:09:58
9	23-Jul-23 15:26:00	00:05:00	00:00:05
10	23-Jul-23 15:27:00	06:21:00	00:06:21
11	23-Jul-23 17:22:00	00:05:00	00:00:05
12	23-Jul-23 17:53:00	00:04:00	00:00:04
13	23-Jul-23 17:58:00	00:05:00	00:00:05
14	23-Jul-23 17:58:00	00:06:00	00:00:06
15	23-Jul-23 18:03:00	06:07:00	00:06:07
16	23-Jul-23 18:23:00	06:31:00	00:06:31
17	23-Jul-23 18:45:00	10:00:00	00:10:00
18	24-Jul-23 8:19:00	04:42:00	00:04:42
19	24-Jul-23 10:03:00	06:58:00	00:06:58
20	24-Jul-23 12:39:00	02:17:00	00:02:17
21	24-Jul-23 13:34:00	00:03:00	00:00:03
22	24-Jul-23 13:35:00	00:08:00	00:00:08
23	24-Jul-23 13:35:00	00:05:00	00:00:05
24	24-Jul-23 16:24:00	01:28:00	00:01:28
25	24-Jul-23 16:44:00	00:03:00	00:00:03
26	24-Jul-23 17:09:00	03:11:00	00:03:11
27	24-Jul-23 18:38:00	00:04:00	00:00:04
28	24-Jul-23 18:38:00	04:11:00	00:04:11
29	24-Jul-23 19:20:00	10:00:00	00:10:00
30	25-Jul-23 9:10:00	01:24:00	00:01:24
31	25-Jul-23 11:25:00	01:05:00	00:01:05
32	25-Jul-23 12:10:00	09:20:00	00:09:20
33	25-Jul-23 12:30:00	03:32:00	00:03:32
34	25-Jul-23 14:46:00	02:16:00	00:02:16
35	25-Jul-23 16:30:00	08:51:00	00:08:51
36	25-Jul-23 18:13:00	00:04:00	00:00:04
37	25-Jul-23 18:21:00	00:03:00	00:00:03
38	26-Jul-23 7:17:00	10:00:00	00:10:00
39	26-Jul-23 9:54:00	08:34:00	00:08:34
40	26-Jul-23 11:34:00	04:37:00	00:04:37
41	26-Jul-23 12:09:00	02:38:00	00:02:38
42	26-Jul-23 16:58:00	06:57:00	00:06:57
43	27-Jul-23 7:04:00	03:16:00	00:03:16
44	27-Jul-23 7:57:00	02:52:00	00:02:52
45	27-Jul-23 8:10:00	01:07:00	00:01:07
46	27-Jul-23 9:30:00	02:52:00	00:02:52
47	27-Jul-23 10:38:00	03:45:00	00:03:45
48	27-Jul-23 11:52:00	00:53:00	00:00:53
49	27-Jul-23 12:09:00	01:31:00	00:01:31
50	27-Jul-23 12:21:00	03:10:00	00:03:10
51	27-Jul-23 14:08:00	01:18:00	00:01:18
52	27-Jul-23 16:50:00	00:04:00	00:00:04
53	27-Jul-23 16:54:00	00:02:00	00:00:02
54	27-Jul-23 16:54:00	10:00:00	00:10:00
55	27-Jul-23 18:00:00	10:00:00	00:10:00
56	28-Jul-23 7:29:00	08:48:00	00:08:48
57	28-Jul-23 13:59:00	07:30:00	00:07:30
58	28-Jul-23 16:45:00	10:00:00	00:10:00
59	29-Jul-23 8:28:00	08:08:00	00:08:08
60	29-Jul-23 9:11:00	06:41:00	00:06:41
61	29-Jul-23 16:30:00	07:14:00	00:07:14
62	29-Jul-23 17:24:00	00:03:00	00:00:03
63	29-Jul-23 18:09:00	04:33:00	00:04:33
64	30-Jul-23 9:16:00	06:03:00	00:06:03
65	30-Jul-23 11:23:00	02:12:00	00:02:12
66	30-Jul-23 11:36:00	02:14:00	00:02:14
67	30-Jul-23 12:02:00	01:57:00	00:01:57
68	30-Jul-23 12:51:00	02:03:00	00:02:03
69	30-Jul-23 14:03:00	10:00:00	00:10:00
70	30-Jul-23 16:43:00	02:19:00	00:02:19
71	30-Jul-23 18:20:00	04:26:00	00:04:26
72	31-Jul-23 7:54:00	01:01:00	00:01:01
73	31-Jul-23 9:43:00	00:03:00	00:00:03
74	31-Jul-23 9:44:00	01:44:00	00:01:44
75	31-Jul-23 11:49:00	01:49:00	00:01:49
76	31-Jul-23 15:26:00	01:31:00	00:01:31
77	31-Jul-23 15:44:00	00:04:00	00:00:04
78	31-Jul-23 15:55:00	03:06:00	00:03:06
79	31-Jul-23 16:08:00	03:20:00	00:03:20
80	1-Aug-23 8:19:00	02:15:00	00:02:15
81	1-Aug-23 8:32:00	02:33:00	00:02:33
82	1-Aug-23 9:13:00	01:29:00	00:01:29
83	1-Aug-23 10:49:00	01:46:00	00:01:46
84	1-Aug-23 17:19:00	09:55:00	00:09:55
85	1-Aug-23 18:20:00	10:00:00	00:10:00
86	2-Aug-23 7:24:00	06:57:00	00:06:57
87	2-Aug-23 11:15:00	10:00:00	00:10:00
88	2-Aug-23 13:36:00	07:41:00	00:07:41
89	2-Aug-23 16:40:00	00:03:00	00:00:03
90	3-Aug-23 7:02:00	10:00:00	00:10:00
91	3-Aug-23 7:42:00	00:57:00	00:00:57
92	3-Aug-23 12:40:00	03:15:00	00:03:15
93	3-Aug-23 13:24:00	01:49:00	00:01:49
94	3-Aug-23 14:26:00	01:32:00	00:01:32
95	4-Aug-23 11:33:00	07:35:00	00:07:35
96		399:01:00	6:39:01
97
98		6:39:01
4aa

Cell Formulas
Range	Formula
D2:D95	D2	=C2/60
C96:D96	C96	=SUM(C2:C95)
C98	C98	=SUM(C2:C95/60)

 

[WendyHubard]

Thank you!!!!! That seems to do the trick Thank you all for your help.