ADDING HOURS AND MINUTES

S

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
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Start/finish but work is only a couple hours 1
Timesheet formula help 2
Adding Hours 2
Countdown macro - display settings 2
Schedule Comparison Error - mismatch duration - "The duration you entered isn't supported for this field. type a duration in the standard format" 0
Excel 2003 -- how do I change a time format 3
adding time and splitting the answer 1
Concerting total minutes to hours and minutes 7

Top