ExcelBanter - Summing hours and munites

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Summing hours and munites (https://www.excelbanter.com/excel-discussion-misc-queries/254537-summing-hours-munites.html)

shahalam

Summing hours and munites

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

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

thanks

Gary''s Student

Summing hours and munites

In A1 thru A3 enter:

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

and then format these cells:

Format Cells... Number custom [hh]:mm:ss
--
Gary''s Student - gsnu201001

"shahalam" wrote:

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

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

thanks

Jacob Skaria

Summing hours and munites

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

=(A1+A2)/24

--
Jacob

"shahalam" wrote:

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

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

thanks

All times are GMT +1. The time now is 07:13 PM.