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

9th September 2014 | 12:02

#9 (permalink)

stickandrudderman

Joined: Aug 2006

Posts: 927

Likes: 1

From: Sth Bucks UK

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

0