I'm trying to figure out a formula to calculate the end date and time of a series of jobs given the start date, quantity, run speed and a set up time. Basically in the attached spreadsheet I'd want the user to input the data in columns A:C and cell D1 and the remaining cells in column D and E to calculate from a formula.
I also need to restrict the calculation based on the hours of work in the "hours of work".
Can anyone help? I'm really stuck on this!