Have a look at Chip Pearson's site.

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

Note the downloadable workbook at bottom of page.

BTW........from where did you download the example that would not open and how
did you try to open them?

Supply a URL or two so's one of us can try them.


Gord Dibben MS Excel MVP

On Tue, 19 Sep 2006 18:49:01 -0700, Nismo90tt
wrote:

I need to make a schedule. The schedule will be for a full month. I want to
enter the employee name, the date, the shift they are going to work
(8:45am-7:30pm). I want the spreadsheet to automatically show the hours for
that shift, and then show a total at the end for all shifts of that week. I
would like it to subtract a 45 minute lunch if they work over 6 hours M-F,
and 30 minutes for lunch if they work over 6 on Saturday. I would just like
for the schedule to show the total for each employee for the end of that week
(minus the lunches). And be able for it to not mess up if I enter an
employee "OFF" for a certain day. Any help with this would be appreciated.
I found a few examples, but they would not open up after I downloaded them
and I am not, by any means, a computer whiz. Thanks in advance!