fill cells - between two cells

V

VilMarci

Hi,

I need to make more visual our staffing plan.
Have a table, the first coloumn contains time with an inerval of 00:30,
like:

06:00
06:30
....
20:30
21:00

I neet to find a way to fill the cells eg. between 8:00 and 17:30 that
depend on the staff plan and are stored (changed) in two cells.
Has anybody an idea how to do this?

Thanks,
Marton
 
J

JulieD

Hi Marton

if you'ld like to email me direct (julied_ng at hcts dot net dot au) i'll
be happy to send you a sample worksheet that does this which you can then
customise for your purposes.

Cheers
JulieD
 
Top