Value calculated too early

Maybe you can include an IF() statement in your calculation box that says if the end time is blank (not inputted), then remain blank, otherwise proceed with the calculation....

e.g. =IF(end_time="","",your_current_formula)

replace end_time with the cell address housing that time and replace your_current_formula with your existing formula (minus the = sign).

=IF(D7="","",((Q7-P7+(Q7<P7))*24)+(E7+H7)+((S7-R7+(S7<R7))*24)

The validation I have looks like this:

=$U$7<=10

It works because no value is entered in the cell untill both "in" and "out" cells have been completed. but still wont let me enter the value I get a validation error. Only now I cant enter any value in the cell. There is no value in the cell, yet it is saying that it values over 10.

Thanks,
Simon Green

You'll need to attach a zipped XL2003 sheet explaining the problem...it's hard to picture it.

u7 is the field used in the validation. There is no entry in there. Yet it wont validate an entry on the time sheet.

The 21st of the month is the only place where it is setup properly, so only there can be used for testing
Thanks,
Simon Green

What if you change your data validation formula to:

=OR($U$7<=10,$U$7="")

?