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.