<Resolved> Select range

Hi,

Attached is the file for the reference.
I was working on a table where i'm searching the blank cells with the criteria.

My table starts from 4:30(Column J) and ends at 4:15 (Column CW).

I enter a start time of the shift at CZ2 cell and as per the formula it calculates the end time of the shift at cell DA2.

At cell CY3, i have a formula which counts number of blanks from the given range in cell CY3 to DA2.

If i enter a start range anywhere from 4:30 to 19:30, it gives me correct data but if my range starts from 20:00 then the end time goes to 4:45 (Day changes) and hence it gives me incorrect data.

Eg: if you enter the start time at cell CZ2 as 11:15, available count will show as 21 which is correct because number of blank cells from 11:15 to 20:00 is 21. But if the start time is 20:00, then the available count shows as 47 wherein it should show only 15.
(If you enter the start time as 20:00 then it calculates blank cells from G3 to BR3 wherein i want it to calculate cells from BR3 to CW3 and F3 to G3)

Can anybody help me on this

Regards
Roshan

Yes. It works. Thank you.

Originally Posted by NBVC

Try:

Please Login or Register  to view this content.

in CY3 copied down.