View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary Brown[_4_] Gary Brown[_4_] is offline
external usenet poster
 
Posts: 209
Default Difference in Time

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


--
Hope this helps.
Thanks in advance for your feedback.
Gary Brown


"Linda" wrote:

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.