Log book on a spread sheet

[stickandrudderman]

Thanks for the quick reply.


in K99:
=IF(D99="P1",J99,0)
in L99 you'd have
=IF(D99="P2",J99,0)


But this doesn't seem to make sense as both "IF" result in the same "J99,0"


To explain further:


The J column is the flight duration, eg 1.6 hours.
The K column is P1 total hours
The L column is p2 total hours.


So if I had 100 hours total P1 time and 25 hours total P2 time:
K3 will show 100 and L3 will show 25


Now, I fly P1 for 1.6 hours so I want K4 to show 101.6 and L4 to show 100.


I then fly P2 for 0.5 hours so I want K5 to show 101.6 and L5 to show 100.5


Thanks for looking!


Do I assume that "0" means that nothing will appear in that cell?