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