Assuming that the dates won't be at weekends this version will use the times too
=NETWORKDAYS(A1,B1)-1+MOD(B1,1)-MOD(A1,1)
format result cell as [h]:mm
Assuming that the dates won't be at weekends this version will use the times too
=NETWORKDAYS(A1,B1)-1+MOD(B1,1)-MOD(A1,1)
format result cell as [h]:mm
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks