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.