How to calculate elapsed time between to days excluding weekends.

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