Converting minutes to Hours

[searchingforhelp]

Hi, I hope all is well.
This sheet's objective is to count how many minutes it takes me to complete a project. I created a basic formula, to sum up the numbers in column I. However, the formula in I18 gives me an incorrect amount of 4.25 instead of 21:40. Also, the formula has created unnecessary rows 19-25 for some reason. Is there a better formula to convert the minutes to hours that will also eliminate the unnecessary rows?

Thanking you in advance for any help you can provide.

Timesheet.xlsx
	A	B	C	D	E	F	G	H	I
6	Items	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Total Minutes Worked
7		7/24/2023	7/25/2023	7/26/2023	7/27/2023	7/28/2023	7/29/2023	7/30/2023
8	Project 1	30	60	45	10	120			265
9	Project 2
10	Project 3
11	Project 4
12	Project 5
13	Project 6
14	Project 7
15	Project 8
16	Project 9	300	400	300	200	100			1300
17
18								Grand Total H:M	4:25
19									0
20									0
21									0
22									0
23									0
24									0
25									0
26									21:40
7-24-2023

Cell Formulas
Range	Formula
I8:I16	I8	=SUM(B8:H8)
I18:I26	I18	=I8:I16/24/60
Dynamic array formulas.

 

[searchingforhelp]

Or just use the far simpler formula I suggested.

Ha!. Yes, I checked marked and liked the formula at 11:49 am edt. Let me know if you did not receive it.

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[searchingforhelp]

Glad we could help & thanks for the feedback.

Hi Fluff, I noticed that the formula does not go over 24hrs. Is there a way to add onto the formula so it can continue counting the hours?

 

[Fluff]

You need to format the cell as [h]:mm:ss

 

[searchingforhelp]

You need to format the cell as [h]:mm:ss

Thank you.

 

[Fluff]

My pleasure.