how to allow autoformat of time in excel

[jraju]

Hi,

              When we want decimals, we could set it in excel. Is there any mechanism, in excel, that if i select time format , 01:30 pm, and then enter 0130, it should change itself to 01:30, without manually typing : character. It takes a whole of time to have the time format and then type in each cell. Anybody having solution pl

[Julian]

Hi,

              When we want decimals, we could set it in excel. Is there any mechanism, in excel, that if i select time format , 01:30 pm, and then enter 0130, it should change itself to 01:30, without manually typing : character. It takes a whole of time to have the time format and then type in each cell. Anybody having solution pl

I'm actually not to sure I never use excel hopefully this helps you out.
http://www.extendoffice.com/documents/excel/1547-excel-convert-military-time-to-standard-time.html