How do I calcluate networkHOURS?

S

Sprad-dog

When using "networkdays" formula in Excel, it returns the whole days without
the weekends or holidays. I need a formula that calculates the networkHOURS
between two dates and times with no weekends or holidays. Is there such a
formula in Excel? I would prefer to use formulas instead of VB codes....
But right now I'll take what I can get.
 
R

Rick Rothstein

Assuming your start and end date/time values would always be on a workday, I
would think you could add the following 3 items together to get what you
want...

1. WorkDayEndTime - StartTime
2. EndTime - WorkDayStartTime
3. HoursPerDay * NETWORKDAYS(StartDate+1,EndDate-1,Holidays)

You, of course, will have to flesh the above out with the referenced pieces
of data that you didn't post for us.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating NetworkHours 5
How to calculate the number of Workdays for irregular work pattern 1
Calculate workdays for irregular work patterns 1
putting a calculated field in a table 1
Excel Formula in Access Table field 3
DateDiff 3
Net Work Days in Access? 1
How do I make a formula calculate only working days? 14

Top