Thanks Bob but that still returns 2.25 however I was wrong about there being
non data or empty cell. The cell has 0.00 in it because there is no sign on
or sign off times yet. Cell E11 contains the formula =(D11-C11)*24 to
calculate the difference between sign off and sign on times and the value is
placed in cell E11. Sorry this wasn't clear in my first post.

"Bob Phillips" wrote:

=IF(E11="","",IF(E11=F5,E11,F5))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"dvonj" wrote in message
...
This is a rather complex issue so I will understand if I need to have a
programmer take this on.
Here goes, I need to keep track of driver total hours. Drivers cannot work
over a certain number of hours in a week. There are two shifts an AM sign
on
and sign off time plus a PM sign on and sign off time. To complicate this
each driver is guaranteed a minimum of 2.25 hours for both AM and PM
shifts.
I am using an IF function to validate the value of a cell based on the
amount
of time for each shift. I use a formula to calculate the difference
between
the sign off and sign on times and put that value in a cell then check to
see
if the value meets certain conditions.

If the value returned is grater than 2.25 I place the grater value in
another cell. If the value is less than 2.25 I place 2.25 in the cell. I
then
total the AM and PM times and get the number of hours the driver worked
that
day. The IF function looks like this.=IF(E11=F5,E11,"2.25"). F5 contains
the
value 2.25, the check value. My problem is that the value 2.25 is returned
on
non data or an empty cell. The IF function evaluates non data or an empty
cell to be les than 2.25 thus returning 2.25 giving hours where there
should
not be any for that time period.
Is there a way to create a validation that will ignore an empty cell until
data is supplied?
I apologize for this being so long winded.