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!!!