LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
find the difference between start time and end time when spanning. wahoos Excel Discussion (Misc queries) 8 January 18th 08 06:02 PM
verify use of TIME Function, Find Quantity Level compare to time-d nastech Excel Discussion (Misc queries) 9 July 11th 07 01:58 PM
How to find out a time Keith Excel Discussion (Misc queries) 2 June 8th 07 12:00 PM
Formula to find Stop Time from Start Time and Total Minutes Jonathan Bickett Excel Worksheet Functions 5 March 7th 07 05:22 PM
How can i find time in various time zone? priya_yuvaraj New Users to Excel 1 November 11th 05 05:42 AM


All times are GMT +1. The time now is 06:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"