Input mask for entering time

  • Thread starter Thread starter MG
  • Start date Start date
M

MG

I have created timesheet in Excel and formated the "in
and out" columns as hh:mm AM or PM. Is there a way to
create an input mask (like in Access) to ease the end
user data entry?
 
Sorry, XL does not support input masks. I believe the user will have to
enter the time manually,using a colon to separate hh:mm.
 
*Temporarily* use Auto Correct!

Go to <Tools> <AutoCorrect>
And in "Replace With", enter a period (.)
And in "With", enter a colon (:)
Then <OK>

Most of the office staff is proficient in working "Ten Key", so the period
(decimal point) is almost second nature to them for easy and fast number
entry.

And of course, after the time cards (sheets) are done, just go and change
things back
to normal by deleting the alteration.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



I have created timesheet in Excel and formated the "in
and out" columns as hh:mm AM or PM. Is there a way to
create an input mask (like in Access) to ease the end
user data entry?
 
There's a macro on Chip's page
http://www.cpearson.com/excel/DateTimeEntry.htm
allowing numbers-only time entry. It does -quote:

1 Converted to 12:01:00 AM
23 Converted to 12:23:00 AM
123 Converted to 1:23:00 AM
1234 Converted to 12:34:00
12345 Converted to 1:23:45, NOT 12:03:45
123456 Converted to 12:34:56

HTH. Best wishes Harald
Followup to newsgroup only please.
 
Back
Top