View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Creating and transit time excel formula

If you use the WEEKDAY function on a date it will return 5 for a
Friday and 1 for Monday. Perhaps you can check for these and subtract
48 hours if your dates return these values.

Hope this helps.

Pete

On Oct 3, 3:59 pm, Neal C <Neal wrote:
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