Converting standard time to military time
On Friday, November 20, 2009 at 11:40:16 AM UTC-5, C. wrote:
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.
|