First you count the number of workdays, then multiply by 9 to get hours
worked on those days.

=NETWORKDAYS(A2,A14) where A2 is sept 11, 2008 and A14 is sept 23, 2008

Returns 9 days

Formula is =NETWORKDAYS(A2,A14)*9 returns 81 hours.

If employees get docked one hour for lunch, multiply by 8

NETWORKDAYS needs the Anaalysis Toolpak add-in loaded.


Gord Dibben MS Excel MVP

On Thu, 8 Jan 2009 15:44:50 -0800, DAH
wrote:

This is exactly what we're looking for.... was there an answer?

"Inquiring Exceler" wrote:

Does anyone know how you would calculate work days in hrs. So if the work day
is from 8am to 5pm and I want to calculate to number of hours between 2
dates. Any assistance on this would be appreciated.

"Work Days" wrote:

I have created a spreadsheet in which there is a committed ship date as
opposed to the actual ship date. However, I need this calculated difference
to be in work days. Does anyone have a formula for this?