needing a weekly schedule

[Lumpyd]

I am looking for a simple weekly schedule for my employees. I post this every
week, but would like something that shows a list of employees, days of the
week, daily hours and total weekly hours. I have been trying to build one in
excell (2003?) but am not very good with building macros. Having trouble
getting weekly hours to add up properly. (eg: 10p-4p shift on Monday, 4p-11p
shift on Tuesday etc)

 

[RobertVA]

I am looking for a simple weekly schedule for my employees. I post this every
week, but would like something that shows a list of employees, days of the
week, daily hours and total weekly hours. I have been trying to build one in
excell (2003?) but am not very good with building macros. Having trouble
getting weekly hours to add up properly. (eg: 10p-4p shift on Monday, 4p-11p
shift on Tuesday etc)

I can see why you've got Excel confused. Does "10p-4p shift on Monday"
mean the six hours from 10:00AM to 4:00PM, the six hours from 4:00PM to
10:00PM or the eighteen hours overlapping from 10:00 Monday evening to
4:00 Tuesday afternoon? IF you will be having someone starting a shift
one evening and finishing the next morning (even if it's a minute after
midnight) you will need to add 24 hours for the date change. Macros
souldn't be necessary, as excell's formulas and logical functions like
"IF(" can handle that sort of thing.

 

[Lumpyd]

they would be working from 10a-4p on monday (6 hours) or 4p-10p on a tuesday
or something like that.

 

[RobertVA]

they would be working from 10a-4p on monday (6 hours) or 4p-10p on a tuesday
or something like that.

A found a sheet I made in Excel '97 while experimenting around. It
didn't have separate columns for days of the week as I was just
experimenting with the formulas.

Main field of table

Column A: Employee names
Column B: Start date & time. Format Category as Date, Type as 3/4/07
1:30 PM.
Column C: Quiting time. Same formating as column B
Column D: Time on duty. Formula =C#-B# ("#" represents row number)
Format Category as time, type as 13:30
At bottom of column D: formula =sum(D515)

The formulas and formats appear to be working properly for a shift that
extends across midnight.

IMPORTANT: Test these formulas to make SURE they work for you in your
version of Excel! Other spreadsheet applications would probably have
similar capabilities. Conversion of time to a number might result in a
number that represents a fraction of a day (ex: 12 hours = 0.50).

Columns B through D could be repeated across a page in landscape
orientation for a full week. If you still have trouble fitting it in the
width of the "time on Duty" column could be reduced to zero and the sums
for that day shifted over to under the "Quiting Time" column.

Sums for each employee and the entire staff could be in an additional
column on the right. This wouldn't include provisions for an employee
working a split shift though.

If the person doing the scheduling prefers to see all those columns the
workbook could have separate work sheets for each day, a sheet for the
weekly totals and a sheet to post or distribute to the staff that just
shows the name and start/quiting times. The totals and distribution
sheets could contain formulas that automatically obtain data from the
daily scheduler work sheets.

 

[Lumpyd]

Thank's. I'm not to proficiant with excel, but I'll give it a try. If you
still have it, coule you possible email it to me at (e-mail address removed)?

Thanks again for all your help.

Larry

 

[Echo S]

There's an employee shift schedule (and others) here:

http://office.microsoft.com/en-us/templates/results.aspx?qu=schedule&av=TPL000