get rid of time format w/msec

[Guest]

i have data column with the following format- 04:01:59:22
which means hh:mm:ss:msms
I want to get rid of msec. They dont allow to import this csv to access db.
How to convert hh:mm:ss:msms to hh:mm:ss ????????????????????

THANK YOU!!

 

[Guest]

Highlight the data column with the time format. Go to Format, Cell, Number,
Custom, and select h:mm:ss. Go up to Type (just above your selection) and
change the h to hh.

HTH,

 

[Guest]

I tried , but still have 04:01:59:22 there
(expected value is 04:01:59 after formatting )

 

[Dave Peterson]

I'd use Data|Text to columns.
fixed width
Draw a line only before :22

Then chose to skip that field (do not import)

 

[Guest]

Cool!
Very helpful!
Thank you so much for your help in discovering Excel!