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.
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
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
