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
|