#### johnjr5664

##### New Member

- Joined
- Nov 5, 2011

- Messages
- 4

=IF(AND($E9="IAR",(N12*1440>240)),1,0)

The formula looks at a time value (in hr:mm) and determines if the time exceeds a 4 hour (>240 (minute)) period and another one evaluates to a 1 hour (60> (minute)) period. My not understanding is why the time value in cell N12 has to multiply 1440 minutes, a 24 hour period before it determines whether it's greater than the 4 or 1 hour period?????

The bottom line is: This formula confuses me!!! (N12*1440>240)

Is there a math guru out there that can explain the reasoning behind the math portion???