Where are the hours, in a separate column like if you would have the dates
starting in A10
going down the hours would be in for instance B10 going down? If so use
=SUM(OFFSET($B$10,COUNT(B10:B1000)-1,,-7,))
format as general if decimal values and as [hh]:mm if time values
If in the same cell like 03/01/05 02:00 for 2 hours on March 1st, then use
=SUMPRODUCT(MOD(OFFSET($A$10,COUNT(A10:A1000)-1,,-7,),1))
with dates and times in A
--
Regards,
Peo Sjoblom
