Time between 2 times excluding weekends

Hi

I have 2 dates,
A2 - 19/05/2014 9:03:21 AM
B2 - 6/06/2014 4:21:59 PM

I understand the Networkingdays function however in this occurance I actually need to calculate the number of hours excluding weekend days. Networkdays just gives the result as days ( 14), I can accept it one of 2 ways if either are possible.In total hours or if only in days is possible to have the decimal spots after it showing hours after.

ta

Jezza

Hi,

Please use the following formula in C2, this would give you number of NETWORKDAYS+HOURS as decimals.

=NETWORKDAYS(A2,B2)+((B2-A2)-INT(B2-A2))