PPRuNe Forums - Excel 28 day hours calculation

PPRuNe Forums (https://www.pprune.org/)

- Computer/Internet Issues & Troubleshooting (https://www.pprune.org/computer-internet-issues-troubleshooting-46/)

- - Excel 28 day hours calculation (https://www.pprune.org/computer-internet-issues-troubleshooting/151344-excel-28-day-hours-calculation.html)

longarm

8th November 2004 13:03

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.

one.two.go

8th November 2004 14:47

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.

737TG

8th November 2004 17:48

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.

All times are GMT. The time now is 12:54.