PPRuNe Forums - View Single Post - Log book on a spread sheet

9th Sep 2014, 12:02

#9 (permalink)

stickandrudderman

Join Date: Aug 2006

Location: Sth Bucks UK

Age: 60

Posts: 927

Likes: 0

Received 0 Likes on 0 Posts

I confess that I had some help to get to this:

=if(I13<>ʺʺ,HOUR(I13)+ROUND(MINUTE(I13)/60,1)+0.2,ʺʺ)

where the +0.2 is the extra 12 minutes for taxi time.

Reply