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.





[TABLE="width: 225"]
<tbody>[TR]
[TD="width: 64, bgcolor: transparent"]

Column A​

[/TD]
[TD="width: 85, bgcolor: transparent"]

Column B​

[/TD]
[TD="width: 74, bgcolor: transparent"]

Column C​

[/TD]
[TD="width: 78, bgcolor: transparent"]

Column D​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

​

[/TD]
[TD="width: 85, bgcolor: transparent"]

Start​

[/TD]
[TD="width: 74, bgcolor: transparent"]

Hours​

[/TD]
[TD="width: 78, bgcolor: transparent"]

End Date​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Task 1​

[/TD]
[TD="width: 85, bgcolor: transparent"]

11/15/2018​

[/TD]
[TD="width: 74, bgcolor: transparent"]

87​

[/TD]
[TD="width: 78, bgcolor: transparent"]

?​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Task 2​

[/TD]
[TD="width: 85, bgcolor: transparent"]

0​

[/TD]
[TD="width: 74, bgcolor: transparent"]

45​

[/TD]
[TD="width: 78, bgcolor: transparent"]

?​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Task 3​

[/TD]
[TD="width: 85, bgcolor: transparent"]

?​

[/TD]
[TD="width: 74, bgcolor: transparent"]

56​

[/TD]
[TD="width: 78, bgcolor: transparent"]

?​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Task 4​

[/TD]
[TD="width: 85, bgcolor: transparent"]

?​

[/TD]
[TD="width: 74, bgcolor: transparent"]

34​

[/TD]
[TD="width: 78, bgcolor: transparent"]

?​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Task 5​

[/TD]
[TD="width: 85, bgcolor: transparent"]

?​

[/TD]
[TD="width: 74, bgcolor: transparent"]

44​

[/TD]
[TD="width: 78, bgcolor: transparent"]

?​

[/TD]
[/TR]
</tbody>[/TABLE]


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 ...