Import into excel (Time)
 

Hello, I imported several columns to a spreadsheet. One column is "Time
hh:mm:ss". When I attempt to add the time across multiple cells it comes up
"0".If I double click the cell, it changes the format of the cell and
calculates.

Example: A1 = 00:05:00 After I double click A1 = 0:05:00
B1 = 01:02:00 After I double click B1 = 1:02:00
Total Time = 0 Total Time = 1:07:00

I do not understand why this is happening!!
P.S. I formatted the cells for time "hh:mm:ss"

Import into excel (Time)
 

The reason this is happening is that when you import the times, a vital part
of the Excel UI is not being called. See if you manually type in 01:15:23,
Excel will automatically convert it into a time. The import by-passes this
conversion.

It is, however, very easy to fix. Try this:

In a fresh worksheet type in '01:15:23 complete with the leading single
quote. Excel thinks the value is only Text, not time. In an un-used cell
enter 1. Copy the cell. Then paste/special/multiple onto the pseudo-time.
You will see:

0.052349537

If you now re-format to time, you will get real, genuine, time.
--
Gary''s Student - gsnu200780


"macamarr" wrote:

Hello, I imported several columns to a spreadsheet. One column is "Time
hh:mm:ss". When I attempt to add the time across multiple cells it comes up
"0".If I double click the cell, it changes the format of the cell and
calculates.

Example: A1 = 00:05:00 After I double click A1 = 0:05:00
B1 = 01:02:00 After I double click B1 = 1:02:00
Total Time = 0 Total Time = 1:07:00

I do not understand why this is happening!!
P.S. I formatted the cells for time "hh:mm:ss"

Import into excel (Time)
 

And if the values are in a column, Text to Columns will accomplish the same
thing.
--
Gary''s Student - gsnu200780


"macamarr" wrote:

Hello, I imported several columns to a spreadsheet. One column is "Time
hh:mm:ss". When I attempt to add the time across multiple cells it comes up
"0".If I double click the cell, it changes the format of the cell and
calculates.

Example: A1 = 00:05:00 After I double click A1 = 0:05:00
B1 = 01:02:00 After I double click B1 = 1:02:00
Total Time = 0 Total Time = 1:07:00

I do not understand why this is happening!!
P.S. I formatted the cells for time "hh:mm:ss"

Import into excel (Time)
 

Thank You Gary's Student. Sorry it to so long to reply, just wanted you to
know that your assistance worked and was greatly appreciated.

"Gary''s Student" wrote:

And if the values are in a column, Text to Columns will accomplish the same
thing.
--
Gary''s Student - gsnu200780


"macamarr" wrote:

Hello, I imported several columns to a spreadsheet. One column is "Time
hh:mm:ss". When I attempt to add the time across multiple cells it comes up
"0".If I double click the cell, it changes the format of the cell and
calculates.

Example: A1 = 00:05:00 After I double click A1 = 0:05:00
B1 = 01:02:00 After I double click B1 = 1:02:00
Total Time = 0 Total Time = 1:07:00

I do not understand why this is happening!!
P.S. I formatted the cells for time "hh:mm:ss"