How to calculate elapsed time between to days excluding weekends.

I would like a formula to calculate elapse time between two days and return the result in Days Hrs Mins

Current I got this formula

=D10-C10-((INT(D10)-INT(C10))-NETWORKDAYS(C10+1,D10))

Where C is start time and D the end time

example:

C = 14/10/2009 21:24:04
D = 09/11/2009 09:47:09

The above dates return 17 days 12 hrs and 23 min which is correct.

The problem is the above formula does not work with any date range over 30 days or any dates in the same day for example:
C = 14/10/2009 21:24:04
D = 14/10/2009 23:24:04
The above would return an error.

Can anybody provide me with a formula that actually works for all scenarios.

Please test your solution before posting. Thanks in advance.

Originally Posted by DonkeyOte

If start & end times always fall on working days then:

=NETWORKDAYS(C10,D10[,holidays])-1+MOD(D10,1)-MOD(C10,1)

where [,holidays] is optional parameter

(above formula c/o daddylonglegs)

Does this solved both issues?

Thanks

Originally Posted by DonkeyOte

Are you unable to test ?

Just tested it and it works of for date range in the same day.

But not for range greater than 30 days for example
08/07/2009 17:05 - 03/11/2009 09:29 is returning 23 days, 16 hrs and 23 mins

I really need one formula that works for both scenarios.

Thanks