Hi Kerry,

in an auxilar column use

=time(left(a2,2),right(a2,2),0)

and format

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Kerry O'Brien" escreveu:

I am a meeting planner and regularly get arrival information from my clients
in miliatry format - sometimes even without a colon. I am trying to make a 4
digit
number already on a spreadsheet into a time format. Does anyone know how?
Example: 1135 (should be 11:35 am)
When you click the cell and change format to time - it formats it, but loses
the 1135 time and makes it 12:00 AM.