Consulting | Excel Examples

Entering Time Without the Colon

Keywords: Time, Data Entry, Military Time, Colon

Description: This workbook demonstrates the use of a VBA macro to speed data entry of time.

Tip: You can use an OnEntry procedure to speed entry of time values. Each time you enter data in a cell, a VBA procedure can be run which converts the entry to a valid time value. For example, you can enter the value "1300" and the VBA procedure will convert it to 1:00PM.

Guide to the Example: Enter a time value in the shaded area of sheet1 -- use military time and omit the colon.

Download File: Click Here
Tip: Click on the link above and choose "Save" to download the xls workbook to your hard drive or "Open" to open the workbook inside of your browser.

 

Last modified: May 21, 1996