Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Problem with adding time values
Hello,
I get following data with leading space infront of the values. I tried pretty much everything suggested in news group, anywhere from formatting the cells to removing space and adding. All I get is 00:00:00 in the result cell. However, if I manually remove space infront of each value the sum works fine. Removing space manually is not very productive. I would appreciate if anyone encountered similar problems before and had resolved it. 02:47:19 00:00:01 00:29:19 00:26:17 0:00 Regards, Dan Rao |
#2
|
|||
|
|||
Problem with adding time values
How are you adding them? How are you inputting the times? Is this imported
data? If it is imported, you would need to use Data-Text to Columns and then cut and paste back to the first row. "Dan" wrote: Hello, I get following data with leading space infront of the values. I tried pretty much everything suggested in news group, anywhere from formatting the cells to removing space and adding. All I get is 00:00:00 in the result cell. However, if I manually remove space infront of each value the sum works fine. Removing space manually is not very productive. I would appreciate if anyone encountered similar problems before and had resolved it. 02:47:19 00:00:01 00:29:19 00:26:17 0:00 Regards, Dan Rao |
#3
|
|||
|
|||
Problem with adding time values
I get data in a .csv file. Once I import data I formatt the column with
Custom (hh:mm:ss) and sum the values. Dan Rao "Sloth" wrote: How are you adding them? How are you inputting the times? Is this imported data? If it is imported, you would need to use Data-Text to Columns and then cut and paste back to the first row. "Dan" wrote: Hello, I get following data with leading space infront of the values. I tried pretty much everything suggested in news group, anywhere from formatting the cells to removing space and adding. All I get is 00:00:00 in the result cell. However, if I manually remove space infront of each value the sum works fine. Removing space manually is not very productive. I would appreciate if anyone encountered similar problems before and had resolved it. 02:47:19 00:00:01 00:29:19 00:26:17 0:00 Regards, Dan Rao |
#4
|
|||
|
|||
Problem with adding time values
So then they are imported with a space. Data-Text to Columns should work
nicely to remove the spaces. This seperates the space and time into two columns. You will then have to delete the first column. You should then be able to format as time, and should not have any problems summing the time. "Dan" wrote: I get data in a .csv file. Once I import data I formatt the column with Custom (hh:mm:ss) and sum the values. Dan Rao "Sloth" wrote: How are you adding them? How are you inputting the times? Is this imported data? If it is imported, you would need to use Data-Text to Columns and then cut and paste back to the first row. "Dan" wrote: Hello, I get following data with leading space infront of the values. I tried pretty much everything suggested in news group, anywhere from formatting the cells to removing space and adding. All I get is 00:00:00 in the result cell. However, if I manually remove space infront of each value the sum works fine. Removing space manually is not very productive. I would appreciate if anyone encountered similar problems before and had resolved it. 02:47:19 00:00:01 00:29:19 00:26:17 0:00 Regards, Dan Rao |
#5
|
|||
|
|||
Problem with adding time values
Hello Sloth,
Thanks for the tip, that really did it. Dan Rao "Sloth" wrote: So then they are imported with a space. Data-Text to Columns should work nicely to remove the spaces. This seperates the space and time into two columns. You will then have to delete the first column. You should then be able to format as time, and should not have any problems summing the time. "Dan" wrote: I get data in a .csv file. Once I import data I formatt the column with Custom (hh:mm:ss) and sum the values. Dan Rao "Sloth" wrote: How are you adding them? How are you inputting the times? Is this imported data? If it is imported, you would need to use Data-Text to Columns and then cut and paste back to the first row. "Dan" wrote: Hello, I get following data with leading space infront of the values. I tried pretty much everything suggested in news group, anywhere from formatting the cells to removing space and adding. All I get is 00:00:00 in the result cell. However, if I manually remove space infront of each value the sum works fine. Removing space manually is not very productive. I would appreciate if anyone encountered similar problems before and had resolved it. 02:47:19 00:00:01 00:29:19 00:26:17 0:00 Regards, Dan Rao |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ignore negative values when adding | Excel Discussion (Misc queries) | |||
how do i sum up a column of time values but ignore negative values | New Users to Excel | |||
Ugh..another time and date problem...HELP | Excel Worksheet Functions | |||
Adding values from previous worksheets | Excel Worksheet Functions | |||
time format and adding tiome values. | Excel Worksheet Functions |