How to Add Work Hours to Dates (Mon - Thur) (6:20am and 4:20pm)?

[DerekWooley]

Hello, I am trying to write a formula that calculates theend date of employees based on the calculated work hours that will be added.The employees start at 6:20am and stop at 4:50pm and only work Monday-Thursday.How can I write a formula in Column C below to add the workhours within thosetime constraints for only Mon-Thur? Also, the start date for the next task is immediatelyfollows the previous task so I need it to do Previous end Date +1 day but onlystart on Mondays or Thursdays since those are the only days they work.

Column A​	Column B​	Column C​	Column D​
​	Start​	Hours​	End Date​
Task 1​	11/15/2018​	87​	?​
Task 2​	0​	45​	?​
Task 3​	?​	56​	?​
Task 4​	?​	34​	?​
Task 5​	?​	44​	?​

<tbody> </tbody>

Thank you for any help.

 

[James006]

Hello,

Not a simple thing ...

Had the same issue years ago ... will dive into my archives ...

Just recall Barry Houdini had a brilliant solution ...