# Scheduling Problem

#### larsenee

##### New Member
What I am trying to do is make a schedule for work,
for our AM servers. There's one thing that's keeping
me from getting it right though. We have servers that
come in in the morning (6:00 AM and 8:00 AM), but we
also have servers that come in at 11:00 AM. We count
the number of each and denote it as: 6 + 2. 6 being
the number of AM servers, and the 2 is the number of
lunch servers. I can use the count function to count
everyone, but it automatically adds in the lunch
servers. My questions are:

1. How do I get the program to distinguish between the
two different shifts.

2. How do I get the program to denote the servers as
6+2 as opposed to 8.

larsenee

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.
Hello there larsenee, welcome to MrExcel.com board!

This is the way the current schedule looks. The "# SCHEDULED" has the sum total of employees working that day.

<center>
</center>

This is how I want the schedule to look. Notice that the "# SCHEDULED" denotes between the number of people coming in before 11:00 AM (the first number) and the people who come in at or after 11:00 AM (the second number).

<center>
</center>

In D20 enter:

=SUMPRODUCT(--(D3:D18<TIME(11,0,0))*(D3:D18<>""))&IF(COUNTIF(D3:D18,">="&TIME(11,0,0))>0,"+"&COUNTIF(D3:D18,">="&TIME(11,0,0)),"")

.. copy across as desired.

Note: The cell contents in F9 will skew your results if it is not an actual time value. 11:00 AM-CL is not a valid value if that is what is entered into the cell. If you enter 11:00 AM and use the format hh:mm AM/PM"-CL" then it will show as you have shown in your postings.

HTH

Replies
1
Views
164
Replies
1
Views
212
Replies
1
Views
78
Replies
5
Views
157
Replies
3
Views
222

1,203,223
Messages
6,054,228
Members
444,711
Latest member
Stupid Idiot

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back