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