Hi!

I'm working with an excel spread sheet to calculate the total hours schedule for the week within different departments of our housekeeping office. I need it to total the hours scheduled for each day and then total for the entire week. I'm running into a problem when trying to subtract a half hour lunch from a day, if the shift is 6 or more hours long.
I've been working on this for a few days now, and haven't been able to come up with a solution. And I've searched on this forum for questions similar to mine, but none of the solutions worked in my spread sheet.

Column D has the same formula. Column E has several different formulas I've tried, but none of them seem to work.
excel help.xls