You are here:

Excel/How to make entering time easier in Excel


I want to be able to type 800a and Excel know to convert it to 8:00 AM and 430p as 4:30 PM.  I have the range formatted as Custom h:mm AM/PM but it just leaves it exactly as I type it.  It is not adding the colon or converting the a or p to AM or PM.  I am working in Excel 2013 but I have to save this with a .xls extension because some others are still using Office 2000 version.  If you could help me solve this, I would be forever grateful.  Thanks.

To force Excel to recognize and convert your personalized text strings into real time strings would require VBA, more plumbing than you really gain.  Excel is already very good at using some shortcuts of its own that will save you "some" time already, but not all.  

8 a = 8:00 am

4 p = 4:00 pm

So all your round hour times can be typed quite succinctly.

But any partial hours will require you to type the colon and the space.

4:5 p = 4:05 pm  
About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here


All Answers

Answers by Expert:

Ask Experts


Jerry Beaucaire


Excel Formulas, macros, automation. Microsoft Excel MVP - 2010. Code site with free code snippets and techniques:


Microsoft Excel MVP - 2010. I have my own extensive Excel help/code site: ===================== I have been offering free assistance as an Excel aid on many web sites for many years: ( - JBeaucaire) ======== ( - JBeaucaire) ======= ( - jbeaucaire)

Bachelor's Degree from Azusa Pacific University in Mathematics and Music Composition

Awards and Honors
Microsoft Excel MVP 2010

©2017 All rights reserved.

[an error occurred while processing this directive]