Import into excel (Time)

[macamarr]

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"

 

[Gary''s Student]

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]

And if the values are in a column, Text to Columns will accomplish the same
thing.

 

[macamarr]

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.