Need FORMULA for Date subtract Date equal bussiness hour (don't count weekend)

Hi,
Can you help me to apply your formula

(NETWORKDAYS(A1,B1))+MOD(B1-A1,1)

into below macro:


My current is:

Target.Offset(0, 3).Value = Target.Offset(0, 0).Value - Target.Offset(0, -3).Value

Please help me to modify by using your Formula:

Target.Offset(0, 3).Formula = "=(NETWORKDAYS(A1,B1))+MOD(B1-A1,1)"

Target.Offset(0, 0).Value   is   B1
Target.Offset(0, -3).Value   is   A1

Tried below but wrong:

Target.Offset(0, 3).Formula = "=(NETWORKDAYS(" & Target.Offset(0, -3).Value & "," & Target.Offset(0, 0).Value & "))+MOD(" & Target.Offset(0, 0) & "-" & Target.Offset(0, -3) & ",1)"""

Changes "Value" to "Address":

Target.Offset(0, 3).Formula = "=(NETWORKDAYS(" & Target.Offset(0, -3).Address & "," & Target.Offset(0, 0).Address & "))+MOD(" & Target.Offset(0, 0).Address & "-" & Target.Offset(0, -3).Address & ",1)"

Regards,
tt3