Problems with validation

[Freak01]

I have a spreadsheet with times in a column... The times are airport arrival times. When I have a connecting flight, I have those times in a separate column. I want to disallow any times in the connecting flight column that are less than one hour later from the arrival times in the arrival column

[Domenic]

Assuming that Column A contains arrival times, and Column B contains times for connecting flights, try the following...

1) Select Column B

2) Data > Validation > Setting > Allow > Custom

3) Enter the following formula:

=B1>=A1+1/24

4) Click Ok

If you wish, enter a custom message in the 'Error Alert' tab.

Hope this helps!

[Freak01]

Cool, thanks so much for your help I'll try it and let ya know!

[Freak01]

Yes, yes!! It worked, thank you SO much!