Excluding weekend time 1

[ddrake]

Hello,
I've got two Date/Time fields that I need to subtract one from the other to return a difference between them. Since they're both DT I can do that readily enough, but I'd like to exclude any weekend time in that calculation. Any hints at all would be appreciated. Thank you!

Crystal Reports 9.0
SQL 2K
Win2K Server Pro

 

[synapsevampire]

Here's Ken's standard biz dates formula:

http://www.kenhamady.com/form01.html

-k

 

[ddrake]

Perfect solution! Thank you!