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.

"Sandi" wrote:

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