ExcelBanter - ADDING HOURS AND MINUTES

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

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

- - ADDING HOURS AND MINUTES (https://www.excelbanter.com/excel-discussion-misc-queries/216305-adding-hours-minutes.html)

shane

ADDING HOURS AND MINUTES

How does one add hours and minutes together to be able to get the total hours
and minutes added together: Eg: 12h24 + 14h15 + 10h10 must equal: 36h49

JE McGimpsey

ADDING HOURS AND MINUTES

Format your cells with Format/Cells/Number/Custom:

[hh]\hmm

In article ,
Shane wrote:

How does one add hours and minutes together to be able to get the total hours
and minutes added together: Eg: 12h24 + 14h15 + 10h10 must equal: 36h49

David Biddulph[_2_]

ADDING HOURS AND MINUTES

Put the data in as 12:24 (with a colon instead of the h). Add the cells up
and use [h]:mm as the format for the result.
--
David Biddulph

"Shane" wrote in message
...
How does one add hours and minutes together to be able to get the total
hours
and minutes added together: Eg: 12h24 + 14h15 + 10h10 must equal: 36h49

All times are GMT +1. The time now is 04:01 AM.