End time calculation with working hours

[DurgaGireesh]

Hi Experts,

Please help this senerio

Received time : 12/may/2017 8:40:00 AM
I want to calculate 8 hours Tat with working hours
( 8:00:00 Am to 5:00:00 PM). sat and sun week off..please help

 

[JPARKHURST]

You looking at a formula or a macro?

 

[DurgaGireesh]

Formula

 

[DurgaGireesh]

Iam looking for formula

 

[DurgaGireesh]

Hi Experts Please help i want formula for this senerio