Help on formula

[VBABEGINER]

Hi All,
I don't understand what goes wrong with this formula..

[TABLE="width: 366"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Col AS2[/TD]
[TD]Col AT2[/TD]
[TD]Col AU2[/TD]
[/TR]
[TR]
[TD]Renewal[/TD]
[TD]68:43:42[/TD]
[TD]formula[/TD]
[/TR]
[TR]
[TD]Col AS3[/TD]
[TD]Col AT3[/TD]
[TD]Col AU3[/TD]
[/TR]
[TR]
[TD]Renewal[/TD]
[TD]36:17:57[/TD]
[TD]formula[/TD]
[/TR]
</tbody>[/TABLE]

formula is

=IF(AND($AS2="Renewal",$AT2<=TIMEVALUE("24:00:00")),"Achieved",IF(AND($AS2="Renewal",$AT2>TIMEVALUE("24:00:00")),"Not Achieved","NA")))


=IF(AND($AS3="Renewal",$AT3<=TIMEVALUE("24:00:00")),"Achieved",IF(AND($AS3="Renewal",$AT3>TIMEVALUE("24:00:00")),"Not Achieved","NA")))

output getting..
Not Achieved
Not Achieved

Why less than 24 hour not captured properly..??

 

[AlanY]

what will you get with

=AT2

?

it's probably due to the cell format,

put =AT2 in a empty cell elsewhere in the sheet, what will you get?

also

=AT2*1 as well