Time not adding in Formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sandi - 28 Feb 2007 16:40 GMT

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.....

Signature

Sandi Gardner

Reply to this Message

Niek Otten - 28 Feb 2007 16:57 GMT

Hi Sandi,

Try this:

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

Signature

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.....

Reply to this Message

Sandi - 28 Feb 2007 18:03 GMT

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?

Signature

Sandi Gardner

> Hi Sandi,
>
[quoted text clipped - 6 lines]
> | number that by looking at the numbers included in the fomula is totaly wrong.
> | Is there another way.....

Reply to this Message

Joel - 28 Feb 2007 17:01 GMT

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.

> 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.....

Reply to this Message