# Calculate finish time given start time, working hours and job duration

1. ## Calculate finish time given start time, working hours and job duration

Hi,

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!

Thanks  Register To Reply

2. ## Re: Calculate finish time given start time, working hours and job duration

Hi!
Guess I can figure this out. More fun than Sudoku Do you calculate in whole hours only or in portions. Iow will 4:45 hrs count as 5:00 hrs or as 4:45 hrs?
Get back to you asic.  Register To Reply

3. ## Re: Calculate finish time given start time, working hours and job duration

Here's something to try.
Solved it by introducing a user defined function which calculates the end time based on job data and the workschedule.  Register To Reply