Productivity Time not calculating correctly

[jawaharprm]

Hi,

Productivity time has not calculating correctly can you help on same.

Formula which iam using currently - =IF(A2="","",(NETWORKDAYS(A2,D2)-1-MOD(A2,1)+MOD(D2,1))*24)

enclosed file with for your reference

Thanks
Jawahar

 

[6StringJazzer]

Your results are actually correct but are in units of hours. If you want minutes, multiply by 60. Your last "correct time" example is wrong, by the way.

 

[jawaharprm]

Your results are actually correct but are in units of hours. If you want minutes, multiply by 60. Your last "correct time" example is wrong, by the way.

Hi,
Thanks for your time its working fine.