Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If statement
Please can someone help me on this, I have been struggling with this for
hours and can't find a solution. I want to display a 1 if the time is before 13:00 and a 2 if the time is between 13:00 and 17:00 and a 3 if the time is after 17:00 but I cannot get the if statement to give me the correct result between 13:00 and 17:00. I have tried this but it won't work =IF((D53*24)<=13,"1",IF(D53*24=13<=17,"2",IF(D53* 24=17,"3"))) a 10:00:28 10:01:30 10:02:47 13:00:02 13:12:57 13:19:25 17:06:52 17:11:27 17:14:27 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SQL concatenation statement | Excel Discussion (Misc queries) | |||
SET statement tutorial | Excel Discussion (Misc queries) | |||
If statement | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
How do I fix a circular reference in a financial statement? | Excel Discussion (Misc queries) |