Hello all. I'm looking for some help in building a time calculator for a lab test. I'd like to be able to input the start date and time of the test. Then, based on the schedule of the oven and the total required test time output the end date and time for the test.

My throught process is that based on the start date input, a day of the week can be referenced from the calendar tab and then the defined schedule is used to reach the 300 hour total test time. I'm having a difficult time sorting out how to accomplish this though.

Any help would be much appreciated, please let me know if you need any more information. I've attached a basic sheet to start with.

D0192-07 Run Time Calculator.xlsx