W
Woodchuck
I'm trying to prepare a simple sheet to be used as a schedule for a
department store. This store must close with at lease 5 people on
staff. I'm attempting to create a cell that checks all the employee
times for the day and tell me if there are enough people scheduled for
the store close that day. The same person makes the schedule every
week, and always types them like this "6:30-9" with 9 being a closing
schedule.
I'd like to develop a formula that will check a cell for a value of
"XXXXX-9" where the X's can be wildcards. All I want is the formula to
look at the last 2 characters of the cell and determine if they are a
"-9" and return a TRUE/FALSE result. The second thing I'd like to do
is to check a column for all these TRUE/FALSE results and determine if
there are equal/greater than 5.
I was asked by a friend to look into this because I have minor
experience in excel formulas, but this is way beyond my ability. All
he knows is how to punch numbers in a cell and make them pretty
colors
All your help is appreciated in advance!
Chuck
department store. This store must close with at lease 5 people on
staff. I'm attempting to create a cell that checks all the employee
times for the day and tell me if there are enough people scheduled for
the store close that day. The same person makes the schedule every
week, and always types them like this "6:30-9" with 9 being a closing
schedule.
I'd like to develop a formula that will check a cell for a value of
"XXXXX-9" where the X's can be wildcards. All I want is the formula to
look at the last 2 characters of the cell and determine if they are a
"-9" and return a TRUE/FALSE result. The second thing I'd like to do
is to check a column for all these TRUE/FALSE results and determine if
there are equal/greater than 5.
I was asked by a friend to look into this because I have minor
experience in excel formulas, but this is way beyond my ability. All
he knows is how to punch numbers in a cell and make them pretty
colors
All your help is appreciated in advance!
Chuck