Forum Discussion

Tito1995

Copper Contributor

Mar 09, 2020

If Statement Problem

Hello, I am having some difficulty trying to figure out the right Excel formula and I was hoping to get some help from somebody. Basically, I have a Start Time column, an End Time column and then I...

excel

Tito1995

Copper Contributor

Mar 09, 2020

Patrick2788 I followed the second suggestion that you gave me but I keep getting all "0" for some reason. Excel is not linking the start time/end time range to any hour block cell. Am I missing something in the formula maybe?

Patrick2788

Silver Contributor

Mar 09, 2020

Tito1995

Here is a better look at the custom cell formatting code:

h:mm AM/PM " - 1:00AM"

Tito1995
Copper Contributor
Mar 09, 2020
Patrick2788 I did that but for the first appointment which last from 8:35:16 AM to 9:45:58 AM, I keep getting "0" at the 8:00:00 AM - 9:00:00 AM hour block in cell AA2. I should be getting "1" for that one since the appointment takes place during that hour block and the next one (9:00:00 AM - 10:00:00 AM).
- Patrick2788
  Silver Contributor
  Mar 09, 2020
  Tito1995
  If you're able to upload a workbook (Even the first couple rows and the formula), I can have a look.
  - Tito1995
    Copper Contributor
    Mar 09, 2020
    Patrick2788 I am not able to upload a workbook here. It just allows me to send pictures and links.
    But the formula I am using is this one: =IF(AND(S1>=MIN($Q2:$R2),S1<=MAX($Q2:$R2)),"1","0").