PPRuNe Forums - View Single Post - excel logbooks
Thread: excel logbooks
View Single Post
Old 18th Jul 2006, 17:13
  #2 (permalink)  
737TG
 
Join Date: Jan 2001
Location: Stansted, UK
Posts: 44
Likes: 0
Received 0 Likes on 0 Posts
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