deduct 30 minutes from a shift calculation in hours

[DougAS]

Using Excel, I want to build a spread sheet for up to 10 employees on
different shifts to calculate hours scheduled. I have this part, but what I
need to do now is to deduct the lunch time, say 30 minutes, from the total
hours initially calculated.

 

[Gord Dibben]

See Chip Pearson's site for working with timesheets with luch breaks and
overtime, if applicable.

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


Gord Dibben MS Excel MVP