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

 

[Sunshine8790]

I opened it in desktop and fixed the custom formatting, and when I closed it and re-opened in sharepoint it updated and is working properly!
TYSM!!!

 

[awoohaw]

great. that is good news. Happy to help.

Best Wishes!