I'm trying to calculate the time duration in business hours. The
open/close times are in the following format:

7/28/04 8:09 7/28/04 8:18
5/24/04 10:31 6/8/04 12:13
6/17/04 10:58 6/28/04 8:33

The current formula I'm using is:

=(DAY(B3-A3)*8 + HOUR(B3-A3)+MINUTE(B3-A3)/60)

But I need to account for weekends too. I initially thought that I
could shave off 2 days from 7 day periods, but realized that a three
day period could also include a weekend. Is there any way for excel to
determine if a day falls on a Saturday or Sunday? Any other ideas on
how I could account for weekends??


Thanks in advance.

Jackson