# Determine finish date with some criteria

#### helmi_jusuf

##### New Member
Hi... i am new comer here. It's a nice forum

I want to determine end date of job based on start date and fix duration but with some criteria

i.e for some simulation needed :

Start Date : 06/05/2015 08:00 am
Fix Duration : 12 hrs
End Date : formula ??? (should be 06/06/2015 12:00 pm - exclude rest time & working time stop at 5.00 pm jump to next day)

Start Date : 06/05/2015 08:00 am
Fix Duration : 9 hrs
End Date : formula ??? (should be 06/06/2015 09:00 am - exclude rest time & working time stop at 5.00 pm jump to next day)

Start Date : 06/05/2015 09:00 am
Fix Duration : 36 hrs
End Date : formula ??? (should be 06/09/2015 01:00 pm - exclude rest time & working time stop at 5.00 pm jump to next day)

Criteria :
Work start at 08:00 am
Work end at 5:00 pm
Lunch time 1 hour start at 12:00 pm

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Replies
17
Views
481
Replies
6
Views
462
Replies
9
Views
157
Replies
1
Views
906
Replies
4
Views
518

1,207,290
Messages
6,077,558
Members
446,289
Latest member
excelmaster123_

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back