Date (hours and still counting)
 

I need to have a formula that will do the following:

Count from July 1st, 2005 til present (not past June 24th, 2006).

then provide the number of hours eclipsed based on a sun thru sat 40 hrs per
week. I don't really have to worry about holidays, but might be a helpful
piece of info for future calc's.

TIA,
_Bigred

Date (hours and still counting)
 

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

Date (hours and still counting)
 

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