Subtracting Date/Time w/ Criteria

[dreicer_Jarr]

I wrote the following formula to subtract date/time and convert to minutes. It allows me to exclude anything under or over a specified number (in this case 1300).

=IF(MOD(G2-F2,1)*1440>1300,"",MOD(G2-F2,1)*1440)

I also want the formula to result in a blank when one of the dates/times I am using is blank. So instead of this date/time (8/31/2008 22:40) giving me 80 minutes when compared to a blank, I want the formula to give me a blank. Anytime there is a blank in G and F, I want the result to be blank and not a "false" number. PLEASE ASSIST as I know there has to be an easier way than sorting them all out....

[JBeaucaire]

Please Login or Register  to view this content.