Consulting | Excel Examples
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.