Summing hours and munites

[shahalam]

Dear experts,
I want following result of 30,000:00 hours after summing.

Col A
10,000:00 hours
20,000:00 hours

 

[Gary''s Student]

In A1 thru A3 enter:

=10000/24
=20000/24
=A1+A2

and then format these cells:

Format > Cells... > Number > custom > [hh]:mm:ss

 

[Jacob Skaria]

Try the below formula and custom format the cell to [hh]:mm

=(A1+A2)/24