get rid of time format w/msec
 

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

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,



"agenda9533" wrote:

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

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


"Carole O" wrote:

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,



"agenda9533" wrote:

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

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

Then chose to skip that field (do not import)



agenda9533 wrote:

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

--

Dave Peterson

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

"Dave Peterson" wrote:

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

Then chose to skip that field (do not import)



agenda9533 wrote:

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

--

Dave Peterson