All,
Imagine if you will the following senario...
A shop opens @ 11:00am and close @ 23:00, it has a afternoon break at 16:00
and re-opens at 17:30..
Opening Time - 11:00
Aft Close - 16:00
Re-Open - 17:30
Close - 23:00 - this means a afternoon & evening shift..
I have times going across the screen
A1 B1 C1 D1 etc
07:00 07:15 07:30 07:45 etc
Also in a2,b2,c2,d2 etc I have the amount of people that come throug the
doors at set times...
The idea is to formulise when I need staff with set definitions..
Definition one..1 staff member to work if more than 20 people come through
the door on two consequtive intervals.
Definition Two..staff must work at least 1/2 hour
Definiton Three / Four..some staff work to the end of the afternoon, some
work until say 15 minutes later or earlier..
Definition Five.. If a staff member starts and then finish's they do not
start again..
IF DEFINITIONS CORRECT = 1
So I am looking @ a big formula..
I have used something along the lines of the below
=(if(A1>=STARTTIME,A1<=FINISHTIME,IF(AND(A1>=STARTTIME,A1<=AFTFINISH
TIME),True = formula to definition, False =
IF(AND(A1>=REOPEN,A1<=FINISHTIME), TRUE = formula to definition, False =
"")""))
The above is a teaser..I have done more but have got lost in it so many
times my head hurts...
If you want to ask questions please do...
Thanks for your time. - Would be so much simpler with a 'BUT' formula lol
Bookmarks