Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do a logical test on times in two different formats?
Help another brainlock here. Am trying figure out why this logical
comparison turns out false? I am comparing two different times one being in format 0.206 (4:57 being the time) the other time is MinFltArrival = "13:00". I know this is a unit conversion issue but haven't figured out yet how to deal with it. formatdatetime(cells(Rowx,8)) =0.206 (So 4:57 is in a decimal format.) MinFltArrival="13:00" (13:00 is in hh:mm format) the logical test. ? formatdatetime(cells(Rowx,8)) < format(MinFltArrival, "0.###") False The test should be coming out true because I was hoping to be performing the IF statement of 04:57 < 13:00 and it should be YES. So the question is how can I compare these two times the right way considering one is in decimal format and the other is in hh:mm format? Thanks, Chet |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I use 'CONTAINS' in an IF Logical Test? | Excel Worksheet Functions | |||
Logical test | Excel Discussion (Misc queries) | |||
Logical Test | Excel Worksheet Functions | |||
Logical test | Excel Programming | |||
Logical test | New Users to Excel |