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)