Hope someone can help withthis. I have a spread sheet to plan production in our factory. I need a formula to calculate the finish time of a job when i enter the duration however we do not work 24 hours so need to ignore the time between 21:00 and 06:00.
For example if a 10 hour job starts at 18:00 one day it would not finish until 13:00 the following day i.e. 3 hours day one, 7 hours the next day.
Hope this makes sense and someone can help

Thanks in anticipation
Martin