if cell A2 is less then 1min, i want B2 cell to reflect as Absent. If A2 cell value is more then/equal to 1min i want B2 cell to reflect as Present.

if cell A2  is less then 1min, i want B2 cell to reflect as Absent. If A2 cell value is more then/equal to 1min i want B2 cell to reflect as Present.

For example:
Column A      Column B
  Time               Status
0:00:00            Absent 
0:01:00            Present


Answer

Hi,

Try this

=IF(A2<TIME(0,1,0),"Absent","Present")

more  www.esoftware-shop.com    office2010 word2010 excel2010 cdkey