Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum Time.
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum Time.
On Jul 30, 11:11*pm, 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. Format: Custom [h]:mm |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum Time.
I tried that...
"robzrob" wrote: On Jul 30, 11:11 pm, 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. Format: Custom [h]:mm |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum Time.
What do you get then?
-- Regards, Peo Sjoblom "GEM" wrote in message ... I tried that... "robzrob" wrote: On Jul 30, 11:11 pm, 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. Format: Custom [h]:mm |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum Time.
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. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum Time.
Still 0:00
"Peo Sjoblom" wrote: 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. |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum Time.
Is your calculations set to manual under toolsoptionscalculation? If so
set it to automatic -- Regards, Peo Sjoblom "GEM" wrote in message ... Still 0:00 "Peo Sjoblom" wrote: 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. |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum Time.
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. -- David Biddulph "GEM" wrote in message ... Still 0:00 "Peo Sjoblom" wrote: 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. |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum Time.
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!!! "David Biddulph" wrote: 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. -- David Biddulph "GEM" wrote in message ... Still 0:00 "Peo Sjoblom" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate Ending time using Start Time and Elapsed Time | Excel Worksheet Functions | |||
Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
template or formula for start time -finish time -total hours ple | New Users to Excel | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Remove time from a date and time field? Format removes the displa. | Excel Worksheet Functions |