employee schedule

G

Guest

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

Gord Dibben

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
 
G

Guest

Sorry, but I still don't quite get it. I tried using what he did, but it
came up with a #value error. Not sure even what that is. I appreciate the
help, but I don't know that I will ever figure this out. May just have to do
it the old fashion way.
 
F

Fred Smith

You don't need to be a computer whiz to get help in this group, but you do have
to tell us what is going on. Where did you get the #Value error? What formula
did you use?

Help is free and quick in this group, but you can't expect people to be
mindreaders.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top