Thread: Sum Time.
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom[_2_] Peo Sjoblom[_2_] is offline
external usenet poster
 
Posts: 964
Default Sum Time.

What do you get if you format the cell as general as opposed to time?

--


Regards,


Peo Sjoblom

"GEM" wrote in message
...
I just get 0:00

"JBoyer" wrote:

You should just be able to simple add them together A1+A2. Make sure they
have a hh:mm or mm:ss format or something like that whatever you are
using.

"GEM" wrote:

If I enter in A1 "1:10" and on A2 "1:20" and try to sum those two
together,
it won't give me an answer. How can I format the cells so that A3 can
give me
the answer 2:30.