This should work option 31 days

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

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Diane13" wrote in message
...
I am trying to figure out how to subtract a cell containing a mm/dd/yyyy
hh:mm format from another cell with the same format and exclude the
weekends.


Example:

A1(received): 7/28/06 15:28
A2(submitted): 7/31/06 16:07
A3 The difference in these two dates and times, excluding the weekend, to
determine the total turn around time.

The answer should reflect 1 day and 39 minutes in a format such as d hh:mm
or any other format that would make this easier.

I have the entire list of Excel functions and have tried all of them that
I
think are logical but I can't seem to get the correct days and time
brought
together into a single cell answer. Any help would be GREATLY
appreciated!

I am using Excel 2003.

Thanks!