Comparing times..

  • Thread starter Thread starter trapani81
  • Start date Start date
T

trapani81

Hi

I am trying to compare a set of times in one cell such as "1200 -
18.00" and then compare this time from another sheet with availability
times such as "13.00 - 17.00" so that I can allocate the right shift
for that person.

What I want to do is to be able to enter a shift and then let excel
accept it using the comparison, or tell me the shift is not suitable.
I am currently using one cell per time slot.

Any ideas would be appreciated.

Thanks
 
My suggestion would be to use separate cells for the beginning and ending time.
Then you will find it much easier to check for availability.

If you need more help, post back with more details
ie, what does "one cell per time slot" mean?
what does availability mean? Does the person have to be available for the entire
time slot, or just any portion of it?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding up total hours worked on employee schedule using various criteria 0
TIME CALCULATION 5
combine vlookup and match help 5
How to check if time falls between two ranges 0
Cell value determined by the current time and date 2
Conditional lookup 2
SSD storage news 6
Keyboard shortcut for current date and time 1

Back
Top