count workweeks or work hours

B

_Bigred

I want to setup a worksheet so I can calculate the ongoing "hours"
accumulated between
7/1/2005 through 6/30/06. (40 hrs p/wk or 80 hrs bi-weekly or 160 hrs
monthly)

how do accomplish this task, I'm using Office XP (Excel 2002)

TIA,
_Bigred
 
P

Peo Sjoblom

=NETWORKDAYS(A1,B1,H2:H12)*8

where A1 is start date, B1 is end date and H2:H12 is a range of cells with
public holidays, if no public holidays you can omit the last part

note that networkdays is part of the Analysis ToolPak which comes with
excel/office, if you get a #NAME! error you need to install it

--
Regards,

Peo Sjoblom

Portland, Oregon
 
P

Peo Sjoblom

Oops, That would give you the hours worked so for an hourly payrate use

=NETWORKDAYS(A1,B1,H2:H12)*8*payrate


--
Regards,

Peo Sjoblom

Portland, Oregon
 
Top