Sum of Hours/Mins

[Sunshine8790]

I'm blanking on what is probably a very simple answer here.
In column G I have "Hours" and in column H I have "Minutes".
In J1 I have "Total time" and in J2 I'm trying to figure out how to get the sum of anything in column G (hours) combined with the sum of anything in column H (minutes).

So in the below example, I want the formula to return: 18 Hours and 21 minutes.
(Not 17 hours and 81 minutes)
Can someone please help me?
Is there a better way to do this to total both hours and minutes together properly if hours/mins goes in one column instead of 2?

Hours	Minutes		Total Time:
-	-		[formula to go here]
-	-
-	-
10	46
-	-
-	-
-	-
7	35

 

[awoohaw]

This will not total if the hours go over 24.

Book1
	A	B	C	D
1	Hours Read	Minutes Read		Total Time Reading:
2	-	-		18:21:00
3	-	-
4	-	-
5	10	46
6	-	-
7	-	-
8	-	-
9	7	35
Sheet4

Cell Formulas
Range	Formula
D2	D2	=SUM(IFERROR(TIME(A2:A9,B2:B9,0),0))

 

[Sunshine8790]

This will not total if the hours go over 24.

Book1
	A	B	C	D
1	Hours Read	Minutes Read		Total Time Reading:
2	-	-		18:21:00
3	-	-
4	-	-
5	10	46
6	-	-
7	-	-
8	-	-
9	7	35
Sheet4

Cell Formulas
Range	Formula
D2	D2	=SUM(IFERROR(TIME(A2:A9,B2:B9,0),0))

Is there a way to total them when they go over 24?

 

[awoohaw]

formula:

=SUM(IFERROR(((A2:A9)/24)+((B2:B9)/(60*24)),0))

format: [hh]:mm:ss

 

[Sunshine8790]

formula:

=SUM(IFERROR(((A2:A9)/24)+((B2:B9)/(60*24)),0))

format: [hh]:mm:ss



View attachment 107589

appreciate this - but it still resets after 24 hours.

If I add "1":

 

[awoohaw]

not for me.
what is the cell format you are using?

Book1
	A	B	C	D
1	Hours Read	Minutes Read		Total Time Reading:
2	-	-		28:21:00
3	-	-
4	10	0
5	10	46
6	-	-
7	-	-
8	-	-
9	7	35
10
Sheet4

Cell Formulas
Range	Formula
D2	D2	=SUM(IFERROR(((A2:A9)/24)+((B2:B9)/(60*24)),0))

 

[Sunshine8790]

not for me.
what is the cell format you are using?

Book1
	A	B	C	D
1	Hours Read	Minutes Read		Total Time Reading:
2	-	-		28:21:00
3	-	-
4	10	0
5	10	46
6	-	-
7	-	-
8	-	-
9	7	35
10
Sheet4

Cell Formulas
Range	Formula
D2	D2	=SUM(IFERROR(((A2:A9)/24)+((B2:B9)/(60*24)),0))

What am I doing wrong?

 

[awoohaw]

use the braces brackets on the hours. it is a custom format [hh]:mm:ss

 

[Sunshine8790]

use the braces brackets on the hours. it is a custom format [hh]:mm:ss

Oh!
I understand what you're saying, but for this spreadsheet I'm utilizing Excel Sharepoint and creating a customized option that isn't listed is not an option. I'll have to figure out a way to work around that.
Thank you very much for your help!

 

[awoohaw]

I'm not familiar with that. But, I find that very strange that it doesn't allow for displaying of accumulating hours.