I am a novice in Excel functions.And have encountered this problem for my management science course.I would be grateful if someone can help me in it. the question is a part of the business simulation model.I need to find the function that can build -
" after every 10 minutes, the server has to rest for 1 minute. He first finishes the service of a customer and then takes the rest".
I have a service start time and server service completion time for each customer.Can any help me with the logic function that can help me build it with the inputs from the cell of service start time and service completion time of servers.If he starts with a customer, take will finish with him even if it crosses 10 mins and takes the rest.Thank you for your help in advance.
" after every 10 minutes, the server has to rest for 1 minute. He first finishes the service of a customer and then takes the rest".
I have a service start time and server service completion time for each customer.Can any help me with the logic function that can help me build it with the inputs from the cell of service start time and service completion time of servers.If he starts with a customer, take will finish with him even if it crosses 10 mins and takes the rest.Thank you for your help in advance.
