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!

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!

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.

"Gord Dibben" wrote:

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!

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.

--
Regards,
Fred


"Nismo90tt" wrote in message
...
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.

"Gord Dibben" wrote:

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!