(877) 729-0812
We connect to your computer over the Internet to...
Answer
i have made the entries correctly, but the total is wrong. pl help, even after deleting and entering...
(More)
Problem for Microsoft OFFICE 2003 BASIC OEM ENGLISH MS (S550039701)
MS excel issue
By mdferozali on Sep 19, 2009
Hi,
I have data in Excel that looks like this:
00:00:10
00:00:20
00:00:40
The data format is ''General''
I want sum these times correctly, so it looks like this: 00:01:10.
It works fine when I do A1+A2+A3.
But when I use the SUM(A1:A3) command, the results are always 00:00:00. This happens no matter how I change the format (i.e. I have changed the results cell to General, TIME, or hh:mm:ss or [h]:mm:ss; and the data cells similarly).
I am using Excel 2003. Can you help?
I have data in Excel that looks like this:
00:00:10
00:00:20
00:00:40
The data format is ''General''
I want sum these times correctly, so it looks like this: 00:01:10.
It works fine when I do A1+A2+A3.
But when I use the SUM(A1:A3) command, the results are always 00:00:00. This happens no matter how I change the format (i.e. I have changed the results cell to General, TIME, or hh:mm:ss or [h]:mm:ss; and the data cells similarly).
I am using Excel 2003. Can you help?
Solution #1
posted on Sep 20, 2009
Using a time format for the data cells and data that looks like 12:00:10 AM the result you want is displayed no matter which formula is used. If the date portion of the data cell is not deleted then the result is 00:00:00. Delete the date portion of your data cells to get the result you want. (For example: When I enter 10 into a cell that is formated for time xx:xx:xx it shows 1/11/1904 12:00:00 AM in the formula bar and 00:00:00 in the cell. When I delete 1/11/1904 in the formula bar and show only the 12:00:10 the cell shows 00:00:10. Then it makes no difference which formula you use.)
Yes
No
Popular Solutions for Microsoft OFFICE 2003 BASIC
Questions and Unsolved Problems for Microsoft OFFICE 2003 BASIC
Do you recommend Microsoft OFFICE 2003 BASIC OEM ENGLISH MS (S550039701)?
Answer
Answer
i want to take features off of my ms office 2003, but it won't because a file PA561401.CAB is...
(More)
Answer
How to write script in VBA which helps to creat a macros in excel. As if now i dont know what is VBA...
(More)
Answer
When attempting to view pictures i keep getting the following mesaage: The selected location does...
(More)
Answer
If the total percentage of x is between 85%-100% then the value should be 5, if the total percentage...
(More)
Ask our Experts
Top Business and Productivity Experts
Top Computer & Laptop Repair
Best Business and Productivity
Recommended by Owners
Recommended by Owners
