PPRuNe Forums - View Single Post - excel logbooks
Thread: excel logbooks
View Single Post
Old 20th Jul 2006, 20:38
  #7 (permalink)  
Keef

Official PPRuNe Chaplain
 
Join Date: Apr 2001
Location: Witnesham, Suffolk
Age: 80
Posts: 3,498
Likes: 0
Received 0 Likes on 0 Posts
Mine does it that way. There are columns off the right hand end of the page, set to zero width, with "IF" statements comparing the date in column 1 with the date now, and showing the hours from column 10 if the difference <31 or <91. Those columns are totalled, and the total appears in the box at the bottom of the logbook.

The same principle counts landings (just in case), Instrument approaches, and suchlike.

It's not elegant, but I understand it and it works.
Keef is offline