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.