Can scheduling counts be done without VBA?

[dereidar]

I can't figure this one out or even know if it can be done without VBA.

I have a worksheet for scheduled work hours. There is a cell for start-time and a cell for end time. There is also a cell that combines the 2 cells in text(A1 and A2) to give A3 "4:00am - 12:00pm" (=list_schedule)

The next worksheet uses Validation List (list_schedule) to assign a person to that work shift.

On the last work sheet is it possible to make header columns with times from 4:00am - 11:00pm in 30min increments and Rows with a date counting how many people are on each shift.

Example,
Sunday: 4a-12p -- 4 people assigned
Sunday 6am-12p -- 3 people assigned,

            4:00  5:00  6:00  7:00  8:00
sunday     4     4       6       6     6

Is anyone willing to have me email it to them? I can't attach files here directly.

 

[Peter_SSs]

Is anyone willing to have me email it to them?

That would not be in the spirit of a public forum like this. Please refer to the Forum Rules, especially #7 and the Posting Guidelines, especially points 18 and 19.

I can't attach files here directly.

Although that is true, you can post small screen shots to give your layout and (copyable) sample data to potential helpers. My signature block below contains 3 methods for posting small screen shots. Test them in the Test Here forum. That way, if something goes wrong, you won’t be messing up a main forum.