G
Guest
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
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