How do I calculate networkHOURS?

  • Thread starter Thread starter Sprad-dog
  • Start date Start date
S

Sprad-dog

How do I calculate networkhours in Excel? I already posted this but the
notification of the response sent me to a dead web page and I could not see
the response..
 
Hi,

I'm not sure what you mean by network hours but the formula for networkdays is

=NETWORKDAYS(A1,B1,Holidays)

A1= First date
B1= later or end date
Holidays is a named range that contains holiday dates.

This will retun a number of days. If you have 8 work hours/day you simply
multiply by 8 to get network hours.

If you want to specify a start time and end time for the first and last day
then that's a bit more involved but post back if that's what you want.

Mike
 
Weren't you able to make use of the instructions I gave you in my answer to
your first posting of this question?
 

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

How do I calcluate networkHOURS? 1
Calculating NetworkHours 5
Workday calculations after 5pm 16
Gmail delays or fails to send 2
What happened here...? 18
AUTOMATIC EMAIL 1
Prefilled Outlook Yes Voting Button response 0
Excel Functions 2

Back
Top