PPRuNe Forums - View Single Post - flight times with MS Excel ... (again)

26th November 2004 | 01:26

#2 (permalink)

drauk

Joined: Sep 2002

Posts: 778

Likes: 0

From: London, UK

Add a column (you can hide it later if you like) which calculates the number of days from the entry till today.

Then use an IF or a DSUM to add up only hours for rows with the above number < 7.