Calculate weekly time taken

[cell-dweller]

Hi
I would like to calculate the time taken for a work order between 2 dates, but need to exclude any week-ends if the date should go across this.
We use network days function to calculate the time, but this includes weekends when we dont work. How can i remove this from our time taken?
Thanks

[outofthehat]

The NETWORKDAYS function excludes weekends (and holidays if you give it some) - that's its purpose.

Note that the start date is counted in the list of days, so

Please Login or Register  to view this content.

gives the answer 6. This might be what's confusing things.

[cell-dweller]

Thanks. My oversight. I also did not give it the Public Holiday lis.