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