You have the solution in a diffrent reply.

but an explanation of why you get 12:00 am

Time and Date formats both treat the underlying general value as a day
value
ie now is 38993.8694444444

The 1135 gets treated as a date ie 2nd August 1903 (uk dates)
and the time element is 0, ie 12:00 AM

Steve

On Tue, 03 Oct 2006 19:10:02 +0100, Kerry O'Brien <Kerry
wrote:

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.