How to use hour as a condition with a IF in DAX

[Natan-npc1]

I'm creating a new column that will return something according to the time in another column. This column that will be consulted does not show the date, it only shows the time (it's like 06:30 for example).

My formula looks like this (and it doesn't work):

IF(TableName[Hour]>= 06:00 && TableName[Hour]< 12:00, "Morning")

I want to do something that shows if it's morning, afternoon or night depending on the information in the [Time] column.

But the above formula doesn't work... I suspect I must convert the "06:00" somehow but I still don't know how.

[Natan-npc1 · Accepted solution]

I solved the problem!
I opened my Excel and put an hour and changed its the type. Instead of hour type I chose to view the data as number.
Then, 06:00 is the same as 0.25, 14:00 is the same as 0.5833 and so on.

IF(TableName[Hour]>= 0.25 && TableName[Hour]< 0.5833, "Morning")