I have a column with some values of times, like below format:
Cell B1 = 3/8/2013 13:00
Cell B2 = 3/22/2013 0:25
Cell B3 = 2/28/2013 13:52
I have to calcuate Time on AM/PM basis as per below instruction:
= If(Cell B1< "01:00:00 PM", 8, 0)
I simply tried to apply this formula to convert the time into text >---> =TEXT(Cell B1,"hh:mm:ss am/pm")
So now it gives me result as GivenTime = 3/8/2013 1:00:06 PM
= If(GivenTime < "01:00:00 PM", 8, 0)
... but it is not giving me the correct result, Can anyone please help me to figure it out.
Thanks in advance!