Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Days in Calender | Excel Discussion (Misc queries) | |||
timesheet with running total of overtime | Excel Worksheet Functions | |||
keep a running total of my formula results after each (F9) | Excel Discussion (Misc queries) | |||
Running Total of Random Number | Excel Discussion (Misc queries) | |||
how do I keep a running total of my bills? | Charts and Charting in Excel |