Forum Discussion

Petter120's avatar
Petter120
Icon for Helper I rankHelper I
6 years ago
Solved

If time value is between two other time values

Hi i have a column that has a time value for example 10:05:22 (hh:nn:ss).    I am trying to figure out how to use an if statement that tests if the time value is between 10:00:00 and 10:59:59 but i...
Need Help
  • AlB's avatar
    AlB
    6 years ago

    Hi Petter120

    If Table[Column1] is what you want to check:

    Table1[Column1] > TIME(10,00,00) && Table1[Column1] <= TIME(10,59,59)

alena2k's avatar
alena2k
Icon for Resolver IV rankResolver IV
6 years ago

hi! if you can do it in power query then I would use conditional column:

 

= Table.AddColumn(#"Prev Table", "Flag", each if ([Time] > #time(10, 0, 0) and [Time] < #time(11, 0, 0)) then "Yes" else "No")

 

if it is indeed inside one our, there is Start of the Hour option:

 

= Table.AddColumn(#"Prev Table", "Flag", each if Time.StartOfHour([Time]) = #time(10, 0, 0) then "Yes" else "No")