Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating NetworkHours
I need some help calculating the networkhours between 2 dates. i dont want
weekends or holidays included. THe hours are from 8am-5pm. i have tried almost every formula i can find on the internet with no luck. i have dates starting at random times throughout the week. I am using a NOW() formula in a cell for the end date. I want to be able to drag down the formula and calculate the rest of the cells. Please help! Start Time 7/7/2009 12:02 7/22/2009 9:32 7/7/2009 11:12 7/8/2009 13:01 7/7/2009 10:26 7/16/2009 13:28 7/19/2009 21:01 7/3/2009 11:41 7/8/2009 10:03 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculating | Excel Worksheet Functions | |||
calculating row by row | New Users to Excel | |||
calculating the mean | Excel Worksheet Functions | |||
Calculating APY for CD | New Users to Excel | |||
Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions |