Sum Time.

G

GEM

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

robzrob

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.
Click to expand...

Format: Custom > [h]:mm
 
J

JBoyer

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

GEM

I just get 0:00

JBoyer said:
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.
Click to expand...
 
P

Peo Sjoblom

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

--


Regards,


Peo Sjoblom
 
P

Peo Sjoblom

Is your calculations set to manual under tools>options>calculation? If so
set it to automatic

--


Regards,


Peo Sjoblom
 
D

David Biddulph

I'm surprised that you get a display of 0:00 in a cell formatted as general.
I would have expected it to change to 0.

What do you get when you temporarily format your original 1:10 to General or
Number? It should show something like 0.048611.
 
G

GEM

After a couple of times of errors, I just copied the whole column to notepad
and then back to excel, and it worked!! Something was wrong with the format.

Thank you all for your help!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting question: how to format duration (time spent)? 0
Subtracting time...again 2
Excel - Wich Function should I use? 1
Conditional Formatting - Given dates within certain range of days 4
Spreadsheet question 5
Sum of Variable Cells in a fixed Row 3
Finding and copying whole rows 1
Calculate end date and time 1

Top