Hi!

If someone is off on a day then there will not be an "In" or "Out" time. So,
maybe something like this:

=IF(COUNT(N3:O3)<2,0,TEXT((O3-N3)-TIME(0,30,0),"h:mm"))

Biff

"Paul" wrote in message
...
In my last discussion, I needed to deduct a lunch period without listing
an
in and out time. That problem was rectified. Thank you Gord Dibben!!! Now
I
want to total the number of scheduled hours for the week. If I have an
associate scheduled off for a day, the daily hours worked calculation is
blown, thus no week total is available. Here's an example of the daily
hours
worked formula - =TEXT((O3-N3)-TIME(0,30,0),"h:mm"). I have created
dropdowns
for the in and out cells that contain times (ie 7:00 AM, 6:00 PM). I would
like to be able to have a zero time worked value in the daily hours worked
cell, which I believe should take care of my weekly total hours worked
formula.

Thank you in advance!!!

Paul