Numeric value as a target for [mm]:ss

[qwerty78]

Hi

I'm trying to validate a result where the target is a numeric value but the result from calculation is minutes and seconds

example:

A1= 240 (target minutes)
A2= 195:23 (calculated value between two dates and times)
A3 = if(a2<=a1,"Met","Miss")

I understand the calculated value is really a serial number of time. How can my if statement work. Please

 

[pgc01]

Hi
Welcome to the board

The time unit in excel is the day. This means that to convert a decimal minute value to excel time you have to divide it by 24 (hours) and by 60 (minutes)

Your formula would be

= if(a2<=a1/24/60,"Met","Miss")

Another way is to use the Time() function:

= if(a2<=TIME(0,a1,0),"Met","Miss")

 

[qwerty78]

Thanks for the input, I have resolved this issue in another way similar to your first formula.