Fill cells with x's between 2 specific columns

M

mcwhirt3

Hi,

I am creating a timesheet for scheduling cashiers at a business. It
basically has by column:

1) cashier name
2) start time
3) end time
....then there is a column for every hour the store is open from 8:00am
to 9:00pm (8 columns in 1 hour increments). this makes 11 columns on
the sheet total.

Next to the cashiers name I would like to fill in their start time and
end time and then have x's populate the cells between those 2 times. I
would then repeat this with every cashier by row and be able to see an
overlay of how many cashiers are scheduled every hour. I have been able
to make an x populate in the column with the start and end times with
If..Then statements but have not been able to figure out how to make
the cells in between populate with x's also. Any ideas on how to make
this happen would be greatly appreciated. Thanks!
 
R

Rowan Drummond

8:00am to 9:00pm is 13 hours so you would need 13 columns for the hours
not 8. So if you add the headings as follows:
A1 Name
B1 Start Time
C1 End Time
D1 8:00
E1 9:00
F1 10:00
etc
P1 20:00

Then in D2 enter the formula:
=IF($B2>D$1,"",IF($C2=0.875,"x",IF($C2>D$1,"x","")))
Copy it accross to P2 and down as far as required.

Hope this helps
Rowan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top