Excel 28 day hours calculation
Thread Starter
Joined: Aug 1999
Posts: 342
Likes: 0
From: uk
Excel 28 day hours calculation
Can anybody help me with an excel formula that can calculate my 28 day flying hours. At the moment I'm doing this manually by selecting cells on a second worksheet but it would be useful to have an automatic function.
Joined: Nov 2000
Posts: 16
Likes: 0
Longarm
I am using an excel spreadsheet in a Psion PDA to keep my logbook. My total hours are displayed in column N. In column O I have the 28 day running total.
If you start on day 29 of your log and put in the formula =N29-N1, followed on line 30 by =N30-N2 this should calculate your running 28 day total. (You should then be able to run autofill to programme the rest of your rows)
Hope that helps.
I am using an excel spreadsheet in a Psion PDA to keep my logbook. My total hours are displayed in column N. In column O I have the 28 day running total.
If you start on day 29 of your log and put in the formula =N29-N1, followed on line 30 by =N30-N2 this should calculate your running 28 day total. (You should then be able to run autofill to programme the rest of your rows)
Hope that helps.
Joined: Jan 2001
Posts: 44
Likes: 0
From: Stansted, UK
On a new column, use the formula =SUM(C1:C28) in the 28th cell and drag this formula to fill down as much as you need. The values will be incremented automatically ie. the 29th row will have the formula =SUM(C2:C29) giving you your running 28 day total.
EASY.
Cheers.
EASY.
Cheers.
