Tweaking.com Support Forums

Main Forum => General Computer Support => Topic started by: jraju on June 16, 2015, 12:43:15 am

Title: how to allow autoformat of time in excel
Post by: 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

Title: Re: how to allow autoformat of time in excel
Post by: Julian on June 16, 2015, 01:36:53 am

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

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