Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula percentage problem | New Users to Excel | |||
formula problem | New Users to Excel | |||
Problem with Formula | Excel Worksheet Functions | |||
problem with Array Formula | Excel Worksheet Functions | |||
Baffling formula problem | Excel Discussion (Misc queries) |