Formula Problem - Get your brain around this..
 

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=START TIME,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