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

On Tue, 15 Jan 2008 15:46:00 -0800, DougAS
wrote:

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.