PPRuNe Forums - View Single Post - excel logbooks
Thread: excel logbooks
View Single Post
Old 18th July 2006 | 17:13
  #2 (permalink)  
737TG
 
Joined: Jan 2001
Posts: 44
Likes: 0
From: Stansted, UK
It is simple.

Use the formula "=sum(a1:a28)" to find the total for a series of 28 days and use the FILL DOWN function (CTRL D) or drag the cell down by the "HANDLE" to automatically continue your 28 day calculation forever!

It makes life much easier if your data includes ALL dates (even those with no flying)...

737TG is offline