convert to hh:mm:ss in excel

Microsoft Microsoft office excel 2007 ac...
November 12, 2010 at 15:36:05
Specs: Windows XP
have a bunch of imported data in an worksheet where the time is in format I want to import this into an Access DB but it isn't being recognized as a time format. I have tried to change the cell format to be hh:mm:ss, but i refuses to change it. Any ideas?

See More: convert to hh:mm:ss in excel

November 12, 2010 at 16:09:43
With your HH.MM.SS Time in cell A1 try the formula:


You will then need to make the cell real times, not just cell with formulas.
Hightlight the cell,

On the Task Bar,
On the Task Bar,
Paste Special
Select Values
Click OK


Report •

November 15, 2010 at 09:06:08
Thanks for the reply Mike, Took me a few tries to realize I had to copy to the other rows before I did the conversion to values, but it works great!

Report •

November 15, 2010 at 10:14:54
Glad I could help.


Report •
Related Solutions

Ask Question