I need help with a formula.

  • Thread starter Thread starter QA Queen
  • Start date Start date
Q

QA Queen

I've subtracted two dates and now I want to do a IF statement. Do I have to
convert to numeric to do that? It's not bringing up correct values. At this
time H7 equals :45. How do I get the formula to work?

=IF(H7<=35,"On Target","Not on Target")
 
Hi QA,

Your question isn't entirely clear, however I think
this is what you are looking for.

=IF((H7*24*60)<=35,"On Target","Not on Target")

The extra brackets are not necessary.
Time is stored as a fraction of a day
so multiplying by 24 takes it to hours
then multiplying by 60 takes it to minutes.
Of course you can just multiply by 1440

HTH
Martin
 
One other guess ..

If H7 would contain textstrings
such as the one you posted, ie: ":45"
where you want to compare the number after the colon

then you could try in say, I7:
=IF(TRIM(H7)="","",IF(RIGHT(H7,LEN(H7)-SEARCH(":",H7))+0<=35,"On
Target","Not on Target"))
 
Back
Top