Modified NETWORKDAYS Formula

[Tha Rippla]

Alright guys - bit of a noob here, and I need some help.

While searching online, I found this formula to calculate NETWORKDAYS down to the time (not just by date):

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

It seems to work well, and so I hope it is accurate. For my own sanity (and as an excuse to learn), can someone explain the difference between that function and =NETWORKDAYS(A1,B1)? Is the above formula accurate for finding the amount of time elapsed between two dates including time (and not including weekends)???

Thank you!

 

[svendiamond]

This link may help: Extract Time with the MOD Function in Excel | Excel Semi-Pro

 

[Tha Rippla]

And that would do it. Thanks so much!