I'm trying to add time differences in h:mm:ss, but SUM won't work

  • Thread starter Thread starter Emily
  • Start date Start date
In the future, keep your subjet line short, and post the majority of your
question in the body.

SUM is used to add a range of cells together. If you want the time
difference between two cells, simply subtract them, and format cells as
h:mm:ss
=A3-A2
or
=TEXT(A3-A2,"h:mm:ss")

Where A3 is the later time, A2 is the first/earlier time.
 
seems this would require some more information. Are you summing more than 24
hours? If so, go to Format Cells and change to Custom formattiing, [h]:mm:ss
 
Maybe you just have to format the cell with the formula(s):
[hh]:mm:ss

If this doesn't help, you may want to explain what's going wrong.
 
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

trying to add numbers in a column 3
How to type format time in decimal format & calculate time 1
How to type format time in decimal format & calculate 1
Excel 2003 - Time Formats 5
time format 1
How to format time in decimal format & calculate time 4
elapsed time calculation 1
Working with times as conditions in formulas 2

Back
Top