Calculating time to fix

[reesie]

Hi

Hopefully someone can assist.

I have a worksheet that shows a job per row. I need to calculate the time to fix the job in business hours monday to friday.

For example:

A1 contains Date and time Reported
D1 contains Date resolved or could be blank if not yet resolved

Business hours are 09:00 to 17:00 - need a formula to calculate the time to fix if D1 is not blank.

Thanks in advance

[ChemistB]

Try this

=IF(D1<>0,(NETWORKDAYS(A1,D1)-2)*8/24+MOD(A1,1)-"9:00"+MOD(D1,1)-"9:00","")