| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting standard time to military time
Hi all,
I've been having some trouble with time conversion and can't seem to find the answer - I'm hoping someone can help me out. I have data (general format) in excel listed exactly as: Sep 22 2009 4:43PM and I need data to be converted into exactly this format: 22-SEP-2009 16:43:00 I have many cases in the former format and need them all to be in the latter. Any suggestions? Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting Standard Time to Military Time in Excel | Excel Discussion (Misc queries) | |||
| formula for converting military time to standard time, etc | Excel Discussion (Misc queries) | |||
| Converting Standard Time into Military Time | Excel Discussion (Misc queries) | |||
| How to I convert standard time to Military or 24 hour format? | Excel Discussion (Misc queries) | |||
| Convert data into standard military time format | Excel Discussion (Misc queries) | |||
Threaded Mode
