Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calc time value | Excel Discussion (Misc queries) | |||
Calc F9) Button and time. | Excel Discussion (Misc queries) | |||
Time Calc - 24hrs vs 0hrs | Excel Discussion (Misc queries) | |||
time sheet calc by time in and out | Excel Worksheet Functions | |||
Problem with time calc | Excel Worksheet Functions |