Time in data validation?
 

(Using Excel 2002)

I have created a staff timesheet which automatically calculates hours worked
etc. etc. The one thing I can't work out is how to use data validation using
time. In one cell I have the time the person went on lunch, in the next cell
I have the time someone comes back from lunch. I want to make sure that the
second value is at least 30 minutes later (i.e. they have to take at least 30
minutes for lunch). How do I achieve this? (In all cells I am using [h]:mm
format for time)

Assuming the time the individual left for lunch is in A1 and time returned is
in B1, select B1, go to Data Validation, select Custom and use:

=$B$1-"00:30"=$A$1

HTH
Jason
Atlanta, GA

"Cymro" wrote:

(Using Excel 2002)

I have created a staff timesheet which automatically calculates hours worked
etc. etc. The one thing I can't work out is how to use data validation using
time. In one cell I have the time the person went on lunch, in the next cell
I have the time someone comes back from lunch. I want to make sure that the
second value is at least 30 minutes later (i.e. they have to take at least 30
minutes for lunch). How do I achieve this? (In all cells I am using [h]:mm
format for time)