I am attempting to create a spreadsheet that reads one column that is formatted as hh:mm:ss and determine whether that column has failed a timed event. anything above 00:02:00 would be a fail and anything below or equal to 00:02:00 would be a pass. The formula I am trying to use is =IF(L2<=00:02:00,"Pass",IF(L2>00:02:00,"Fail")), L being the column the time is in.
Can somebody explain to me why this isn't working and offer any solutions that may?
Bookmarks