How to sum a column to equal hours and minutes in Excel?

K

Kim

I need to formulate a column to add time and convert it to hours and minutes.
I have tried the Sum formula and then changed it to hours and minutes in the
format cell area but it does not work. My results are 00:00. If anyone can
help I would appreciate it.
 
M

Mike H

Hi,

=Sum(A1:a100) formatted as [hh]:mm would do that. If it's not working in
your case are you sure you have properly formatted times in your column?

Mike
 

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

Cumulative formula for word table 0
Adding Hours & Minutes 3
Time Sum in Excel 1
Time Zone Conversion Table 1
Converting Seconds to Hours, Minutes, Seconds 3
sum hours and minutes with Excel 2000 9
End Date/Time adding business hours 1
Converting hour/minutes to hours/hundredths 1

Top