Author Topic: how to allow autoformat of time in excel  (Read 8402 times)

0 Members and 1 Guest are viewing this topic.

Offline jraju

  • Hero Member
  • *****
  • Join Date: Feb 2013
  • Posts: 2323
  • Location: india
  • Karma: 17
    • View Profile
how to allow autoformat of time in excel
« 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
The Bottom line is "Check your hardware first if it supports the task you try".

Offline Julian

  • "Professional Googler"
  • Global Moderator
  • Hero Member
  • *****
  • Join Date: Jun 2015
  • Posts: 1325
  • Location: USA, New Mexico
  • Karma: 38
    • View Profile
Re: how to allow autoformat of time in excel
« Reply #1 on: June 16, 2015, 01:36:53 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
Julian