Time not adding in Formula

[Guest]

I am trying to add together numbers that are formatted as time, ex: 6:45:02
When I tried to use the sum function to add them together it gives me some
number that by looking at the numbers included in the fomula is totaly wrong.
Is there another way.....

 

[Niek Otten]

Hi Sandi,

Try this:

Format>Number>Custom, [h]:mm:ss

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I am trying to add together numbers that are formatted as time, ex: 6:45:02
| When I tried to use the sum function to add them together it gives me some
| number that by looking at the numbers included in the fomula is totaly wrong.
| Is there another way.....
| --
| Sandi Gardner

 

[Guest]

Any time format is a count in days from Jan 1 1900. You can't add Jan 5 2007
+ february 1, 2007 because that doesn't make sense. You can add Jan 5 2007 +
10 hours.

the answer to your problem may be that your answer just needs to be
converted to date format. Change the format where the SUM formul exists to
datta format.

 

[Guest]

I formatted the number that way and it appears to work, but if you manually
go in and add the numbers together it's different. Any reason?