Forum Discussion

alexw94's avatar
alexw94
Copper Contributor
Apr 24, 2023
Solved

Please help - COUNTIFS formula between 2 different time periods returning 0 all the time

So I am trying to get a value to to be returned in the following formula. I have a list of data on "Sheet 1" which shows a list of people and a number times during the 24 hour clock. I am wanting to ...
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Apr 24, 2023

    alexw94 

    =COUNTIFS(G:G,">="&A2,G:G,"<"&A3)

    The formula works in a similar example. Are there values between 0 and 1 in your Sheet1 column D?

     

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Apr 24, 2023

alexw94 

=COUNTIFS(G:G,">="&A2,G:G,"<"&A3)

The formula works in a similar example. Are there values between 0 and 1 in your Sheet1 column D?

 

  • alexw94's avatar
    alexw94
    Copper Contributor
    Apr 25, 2023
    OliverScheurich, the numbers are in time, HH:MM:SS.

Resources