J
Jimbo
I have a staffing spreadsheet and I need to have a multiple if
statement and I cannot figure it out.
I have A1 7:00 am, B2 4:00 PM B3 & B4 Break start and stop times, B5
& B6 Lunch break times, B7 & B8 Break times.
I have the Following columns set in 15 minute increments.
I want to receive a value of a "1", if It falls between A1 & B1, but
blank if it falls between breaks and lunches.
Your help would be appreciated.
Thank you
statement and I cannot figure it out.
I have A1 7:00 am, B2 4:00 PM B3 & B4 Break start and stop times, B5
& B6 Lunch break times, B7 & B8 Break times.
I have the Following columns set in 15 minute increments.
I want to receive a value of a "1", if It falls between A1 & B1, but
blank if it falls between breaks and lunches.
Your help would be appreciated.
Thank you