Paul

Perhaps Chip Pearson's site on timesheets will give you the rest of what you
need.

http://www.cpearson.com/excel/overtime.htm


Gord Dibben Excel MVP

On Wed, 7 Dec 2005 14:49:03 -0800, "Paul"
wrote:

I am so close to completing a scheduling worksheet, but have a problem with
one of the formulas. I have created dropdowns for 'in' and 'out', using AM &
PM for the times, a formula to calculate the daily number of hours and a
formula to calculate the total number of hours scheduled for an entire week.
My problem is that I want to deduct lunch periods from the daily schedule,
but have been unable to figure out that calculation. I want to be able to
deduct :30, :45, and :60 minute lunches. At this point, I would even settle
for the ability to deduct a fixed time period of :30 minutes. Any suggestions
are very much welcome!!!