Use Data Validation, with a type of Custom, and a formula of

=AND(INT(B3)=A3,MOD(B3,1)=--"08:30:00",MOD(B3,1)<=--"08:45:00")

--

HTH

Bob

"Freshman" wrote in message
...
Dear experts,

In my worksheet, column A is for default dates of each month and column B
is
for recording staff's reporting time. I want the cells in column B can
only
accept the current computer time between 8:30 am to 8:45 am on current
date
only. For example, the current date and time is 8 March 2010 and 8:37 am.
In
cell A3, the date is already 8 March 2010, then the user inputs the time
8:37
am in B3. Either the user inputs the time next to the current date is
incorrect or input the time outside the default time range - 8:30 am to
8:45
am, the cell will not accept the input. Is it possible? If yes, what will
be
the formula or macro code? Please advise.

Thanks in advance.