PPRuNe Forums - View Single Post - Another Excel Question - this time about "hours"
Thread: Another Excel Question - this time about "hours"
View Single Post
Old 15th November 2007 | 18:04
  #2 (permalink)  
MetoPower
 
Joined: Aug 2007
: ATPL
Posts: 57
Likes: 1
From: The World
Try this:

Assuming A1 is OFF CHKS, and B1 CHKS ON, then:
in C1: =IF(B1<A1,B1+1,B1)-A1
Of course do not forget to format hh:mm

MP
MetoPower is offline  
Reply
0