Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating and transit time excel formula
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating and transit time excel formula
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating an Excel Database for my Logged Time | Excel Worksheet Functions | |||
Creating a formula calculates time impact on achieveing sales quota | Excel Worksheet Functions | |||
Creating a Formula to Calculate Time Value in an Option | Excel Worksheet Functions | |||
creating a time formula | Excel Worksheet Functions | |||
Formula Needed for Transit Time | Excel Discussion (Misc queries) |