Amean1

New Member
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.

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
Amean1 said:
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

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

Amean1 said:
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

Custom format as [hh]:mm not just hh:mm
Book1
ABCD
129:30
235:45
345:20
4110:35
Sheet1

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

Replies
1
Views
250
Replies
3
Views
158
Replies
4
Views
133
Replies
12
Views
269
Replies
3
Views
136

1,206,808
Messages
6,074,985
Members
446,111
Latest member
trduy1908

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back