Help with Adding Hours.Minutes

[Amean1]

I am trying to figure out the formula to be able to add Hours.Minutes. For Example 59.35 + 34.45 = 94.20

Any help would be greatly appreciated.

 

[Brian from Maui]

I am trying to figure out the formula to be able to add Hours.Minutes. For Example 59.35 + 34.45 = 94.20

Any help would be greatly appreciated.

Assuming you mean 59:35 and 34:45 which sre true time values, custom format the cell that houses the addition formula as [h]:mm

 

[Amean1]

Problem I have that with custom format h:mm, I can only enter the values upto 23:59 (24Hrs). I would like to be able to enter any hour and minute values in the cell and be able to add them as total hours and minutes.

For Example
A1 = 29:30
A2 = 35:45
A3 = 45:20

Total = 110:35

Thanks for your help.

 

[Brian from Maui]

Problem I have that with custom format h:mm, I can only enter the values upto 23:59 (24Hrs). I would like to be able to enter any hour and minute values in the cell and be able to add them as total hours and minutes.

For Example
A1 = 29:30
A2 = 35:45
A3 = 45:20

Total = 110:35

Thanks for your help.

Custom format as [hh]:mm not just hh:mm

Book1
	A	B	C	D
1	29:30
2	35:45
3	45:20
4	110:35
Sheet1

 

[Amean1]

Thanks a lot Brian for your help. It works great now.