Hi,

In A2 of my excel sheet, i have the formula as =NOW() which is displaying the time in the format 1.45.00 PM. The time gets updated to current time, every time the sheet refreshes. In cell B2 i have given a formula as =IF(A2>TIMEVALUE("01:45:00 PM"),"TRUE","FALSE"). What ever the time in A2, i always get value in B2 as TRUE.

I have even tried the below formats. The intended logic of the function is not being derived though.

=IF(A2="","",IF(A2>--"01:45:00 PM","TRUE","FALSE"))
=IF(A2>TIME(01,45,00),"TRUE","FALSE")

Is there any error in the formulas or is there any alternate method to get the correct value. I am unable to figure it out. Please assist me to resolve the issue.

I am using Microsoft Excel 2013.