Thread: Sum Time.
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JBoyer JBoyer is offline
external usenet poster
 
Posts: 72
Default Sum Time.

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.