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

"Sprad-dog" wrote:

> 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,

Just spotted you other respondse here

http://www.microsoft.com/office/comm...b-d7f97c160af9

Mike

"Mike H" wrote:

> 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
>
> "Sprad-dog" wrote:
>
> > 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..

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

--
Rick (MVP - Excel)


"Sprad-dog" <(E-Mail Removed)> wrote in message
news:4E60B59A-531E-45A2-9B4B-(E-Mail Removed)...
> 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..