If Statement - in time not decimal minutes

[Guest]

Unfortunately, they are using time. Would I set the formula up to multiply by
1440? =IF(D2-C2)*1440<10,0,IF(D2-C2)*1440<60,1,"")) Thank you for your help!

I am assuming that you use decimal minutes (e.g. 10m for ten mins) not time
(00:10:00).

=IF(D2-C2<10,0,IF(D2-C2<60,1,""))

--

HTH

RP
(remove nothere from the email address if mailing direct)

Expand AllCollapse All

 

[JE McGimpsey]

One way:

=IF((D2-C2)<1/144,0,IF((D2-C2)<1/24,1,""))