If time value is between two other time values

[Petter120]

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 cant figure it out. 

Can anyone help me out here please

Best regards 

Petter

[AlB · Accepted solution]

Hi @Petter120

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

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

[Petter120]

@AlB Thank you so simple 🙂

[alena2k]

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")

[az38]

Hi @Petter120 

there is not enough information.

There are could be a lot of solutions. At the first sight:

1. DATESBETWEEN() DAX function https://docs.microsoft.com/en-us/dax/datesbetween-function-dax

2. IF ([Column] >= TIME(10,0,0) && [Column] <= TIME(10,59,59), true(), false())

3. if(HOUR([Column]) = 10, true(), false())

The appropriate solution will depend on your business logic