thanks much, worked like a charm.

Take Care,
_Bigred



"daddylonglegs"
wrote in message
news:daddylonglegs.25k1zn_1143843905.5607@excelfor um-nospam.com...

The formula

=NETWORKDAYS(DATE(2005,7,1),MIN(TODAY(),DATE(2006, 6,24)))*8

will give you the working hours elapsed (including today). If you want
to add holidays you can add a range of dates as the 3rd argument of
NETWORKDAYS

note: NETWORKDAYS is part of the Analysis ToolPak add-in


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=528712