Inputting formated numbers

Tips1949 

Hi,

attached Excel macroenabled workbook. Open it and enable macros.

Open that worksheet where you are going to input timevalues.

Macro starts to fill values from activecell and below it when you type digits to it.

hit ALT + F8 and select TimeMachine - macro to run.

Macro asks you how many timevalues you want to type, answer some amount from 1 to 30000

type first four digits and hit enter

formatted value appears to active cell and cell below will be selected

this happens as long as counter reach the amount of numbers you told it to be coming from you

you can always stop adding new numbers just hitting enter when macro asks new timevalue

Macro checks that you have given only numbers, no more than 24 hours, no more than 59 minutes

and exactly four digits.

Try this with attached workbook or any other workbook. You only have to open this macro workbook

to reach macro or you can copy the code to your personal macro workbook if you like. That way

it would be always available when you use Excel.