View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Neal C Neal C is offline
external usenet poster
 
Posts: 2
Default Creating and transit time excel formula

I looked at network days but it with this formula I would have to list the
weekends. I was looking for an 'IF, AND, OR' sum but I'm not sure this will
work?


"David Biddulph" wrote:

May be worth looking at the NETWORKDAYS function?
--
David Biddulph

"Neal C" <Neal wrote in message
...
When I create a transit time sum it includes the weekends as it calculates
the time between 2 dates/time. Can anyone help and advise on how I can add
to
my sum to minus the weekends?
Thanks
Neal