Thanks TMS for your response.

I have tried the time format as mentioned by you(=IF(A2>TIME(13,45,00),"TRUE","FALSE")). Still only TRUE gets displayed in B2 though the time in A2 is less than the time mentioned in the formula.