I am trying to create a formula for a spreadsheet that is used as an
employee schedule. I am definetly an excel novice.

Here is what I need it to do.

1. Need to create a counter in 1/2 hour increments that will tell me how
many employees are working each half hour

2. example : employee #1 working 10-1
employee #2 working 11-2

need to get results as follows:

10:00 A = 1 employee working
10:30 A = 1 employee working
11:00A = 2 employees working
11:30 A = 2 ""
12:00 N = 2"
12:30 P = 2"
1:00 P = 2"
1:30 P = 1"
I have already completed the actual schedule part complete with time
calcs and totals. Just need to know what function would work to count the
number of working employees by half hour and output that # to its own cell.