Excel 2007 : Networkdays not bringing in the final jours of a weekday b4 weekend

Hi All,

I hope the title makes sense!!!

I have a formula based on Networkdays, but when a job is logged on a friday and actioned on a saturday we count the response time as when the job was logged (friday) to the end of that day, not using the saturday arrival time as that is classed as out of hours (overtime)

so the background data is hours worked Mon-Fri 8am - 5pm.

I have attaced an example, I need a formula that will count all instances of Mon- Fri 8am-5pm hours worked, along with when a job is logged on a weekday and actioned on a weekend, to count the hours 'til close of play on the friday, instead of giving me ########.

I would be most grateful of any answers.

cheers

Donnascenario 2 get work day hours.xlsx