| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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!! |
|
#2
|
|||
|
|||
|
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!! |
|
#3
|
|||
|
|||
|
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!! |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| entering numbers to display a time format | Excel Discussion (Misc queries) | |||
| How do I format column containing date and time to only show the . | Excel Discussion (Misc queries) | |||
| Time Format Auto Entry AM and PM | Excel Discussion (Misc queries) | |||
| Help Q: Entering 7 p time format, does not convert to 19:00 | Excel Discussion (Misc queries) | |||
| Subtracting time in date format | Excel Worksheet Functions | |||
Linear Mode
