How do I calculate networkHOURS?

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..
 
M

Mike H

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
 
R

Rick Rothstein

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