PPRuNe Forums Excel 28 day hours calculation

 Computer/Internet Issues & Troubleshooting Anyone with questions about the terribly complex world of computers or the internet should try here. We will also try and help with troubleshooting any technical problems you may have with the forums.

 8th Nov 2004, 13:03 #1 (permalink) Join Date: Aug 1999 Location: uk Posts: 342 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.
 8th Nov 2004, 14:47 #2 (permalink) Join Date: Nov 2000 Posts: 16 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.
 8th Nov 2004, 17:48 #3 (permalink) Join Date: Jan 2001 Location: Stansted, UK Posts: 45 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.

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are Off Pingbacks are Off Refbacks are Off Forum Rules

All times are GMT. The time now is 17:06.