match one time to the closest other time

smokenack

Active Member
Joined
Dec 12, 2003
Messages
351
I'm a bit stuck knowing how to start on a new project. I need to match up a shift start time with the nearest start time of the staff available to work. They will rarely match. There may be more shifts than staff available and vice versa.

I just need a prod in the right direction and then should be OK.

thanks

Nick
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
Joined
Jul 30, 2006
Messages
3,656
Nick,

Depending on how your data is setup, you could use Data, Filter, AutoFilter.

In the column for 'start time', click on the down arrow of the filter, and use custom. You can set parameters greater than and less than.

Have a great day,
Stan
 

Watch MrExcel Video

Forum statistics

Threads
1,122,962
Messages
5,599,065
Members
414,281
Latest member
Engjamal2021

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top