Adding Times

  • Thread starter Thread starter mcp6453
  • Start date Start date
M

mcp6453

How do I add times in a column, such as a list of song times for a CD? I
can get a Sum formula to work for about 20 rows, but then the numbers
get small. How should the cells be formatted? The Help file is not very
helpful. The times are in the 12:30 (12 minutes, 30 seconds) format.
 
Format the cell with the custom format [h]:mm:ss

This will display the total in hours, minutes and seconds, even if number of
hours goes over one day. The default format is not displaying the number of
days, so the number gets small when the total goes over 24 hours.
 
You must log in or register to reply here.

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

calculate total hours/minutes from two time cells 7
h:mm:ss formula 4
Offset and Small functions with blank rows? 0
Converting standard time to decimal time 2
Sum number range ignoring numbers formatted as text 0
Compute minutes between hh:mm 2
Excel Catagorise AM or PM 7
calculating time with IF statement 1

Back
Top