Difference in Time

[Linda]

A request came in on 10/21/08 8:00 AM and went out 10/27/08 10:00 AM. I need
to figure the amount of time it took excluding weekends and holidays. Thanks.

 

[Gary Brown]

Assuming:
A1 = 10/21/2008 8:00:00 AM
A2 = 10/27/2008 10:00:00 AM
Formula that returns # of minutes (which you can then change to whatever
measurement you want) =
=((NETWORKDAYS(A1,A2)-1)*24*60)+((MOD(A2,1)-MOD(A1,1))*24*60)
or
5,880 minutes