Converting Military Time to Number

[RLeFebvre]

Hi all,

Tried searching for an existing thread and oculdn't find exactly what I needed, so apologies if it's out there somewhere.

I need to convert military time (h:mm, e.g. 14:00) to the corresponding number (1400), and eliminate any base formatting as time. I'm then analyzing this data in another program which has a hard time with time formats, so if I can take 0:00 - 23:59 and have it all formatted aws 000 - 2359, I'll be golden. Is this possible?

Thanks in advance!

 

[Special-K99]

=TEXT(A1,"hhmm")
where A1 is the military time

 

[mole999]

choices
http://www.mrexcel.com/forum/excel-questions/340814-format-formula-convert-time-text.html