=hours_worked-(hours_worked6)*.5-(hours_worked8)*.5

--

HTH

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


"navychef" wrote in
message ...

Hi - I'm having a heckuva time trying to create a formula that will
enable me to create an employee work schedule that will alert the
manager to scheduled overtimes. The criterium a

- if employee works 6-8 hours, they get .5 hour lunch break that does
not get factored into their total hours for the week

- if employee works 8 hours or more, they get 1.0 hour lunch break

How do I write the formula to recognize if they worked = 6 (but <8)
and =8, and have either .5 or 1.0 hours as appropriate deducted from
the daily total hours?

Assume that start time is A3, end time is B3, and total daily hours is
B4

Once I have that, I can easily total actual paid hours for the week.

THANK YOU THANK YOU THANK YOU!!! :)


--
navychef
------------------------------------------------------------------------
navychef's Profile:
http://www.excelforum.com/member.php...o&userid=29457
View this thread: http://www.excelforum.com/showthread...hreadid=491668