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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks