I put =TIME() in every cell. Why does Excel think it is text? And how do I
change it?

This is just a column of hours that I am trying to sum.

Thanks,

Patti

"Peo Sjoblom" wrote:

Then some of your times are text

--

Regards,

Peo Sjoblom


"Sweetpea60" wrote in message
...
I've tried both of those things and it doesn't seem to work. Sometimes it
will give me a total but the total is not correct.

Thanks

"JE McGimpsey" wrote:

Times are stored by XL as fractional days, so you can simply add them,
or use the SUM() function.

By default, displayed times roll over at 24 hours. To prevent that,
choose Format/Cell/Number/Custom and enter

[h]:mm:ss

in the format box.



In article ,
"Sweetpea60" wrote:

I am trying to add a column of time. It should be simple but I cannot
get it
to work.