Time Calc
I have in one cell (say A1) time displayed as 16:45 (excel shows it as
11/6/2007 4:45:38 PM in the bar at the top). I am trying to create an if
statement in another cell to calculate if the time in cell A1 is between a
certain time frame (say 18:00-23:59) and to give me a 1 or a 0 based on the
calc. How can I convert the time in Cell A1 to a number without the date
showing?
=IF(AND(A1=0.75,A1<1),1,0)
Any Help Greatly Appreciated.
Thanks
Robert B.
|