ADDING HOURS AND MINUTES

[Shane]

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]

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

[hh]\hmm

 

[David Biddulph]

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.