# 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

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.

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.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1