running total for last 7 calender days
 

I have a pilot logbook in excel. I need to find total hours in the last 7
calender days.

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


"md83" wrote in message
...
I have a pilot logbook in excel. I need to find total hours in the last 7
calender days.