View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default Find Best Available time

OK, so I have a spreadsheet with many employees listed.

Each employee has columns for shift start time, break1 start time, break1
end time, lunch start, lunch end, break2 start and break2 end.

I also have a list of meeting times. Each meeting is 50 minutes long.

I am trying to use a formula that will look at all of the columns given and
find where the employee is not on a break or lunch, and is on their shift
that matches one of the meeting times. -Trying to enter meetigns without
moving breaks or lunches.

Is there any way to find this without using a godawful number of if
statements?