Main Forum > General Computer Support

how to allow autoformat of time in excel

(1/1)

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:

--- Quote from: jraju on June 16, 2015, 12:43:15 am ---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

--- End quote ---

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

Navigation

[0] Message Index