get rid of time format w/msec

A

agenda9533

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!!
 
C

Carole O

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,
 
A

agenda9533

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

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)
 
Top