Transform a time range into a word

[Anonymous]

Sorry, my English is bad, I use google translation.

Hello,

I work with a team in 3x8 hours, and I try to do statistics.

Here's what I've been looking for hours:

I have an HH:MM time column (and another hhmm),

example (FR hour Format)

05:00
05:32
13:50
19:30

Instead of these hours, I wish to make appear a word according to the hour:

- "Morning" between 05:00 and 13:00

- "Evening" between 13:01 and 21:00

I tried DAX but I can't do it (probably because I speak the international language badly :(). Also, creating a custom filter did not allow me to carry out the action.

Can you help me please ?

Thanks,

Bastien

[harshnathani · Accepted solution]

Hi @Anonymous ,

Create a Calculated Column

Column =

IF (Hour('Table'[Time]) >= HOUR(Time(5,0,0)) && HOUR('Table'[Time]) <= HOUR(Time(12,59,0)) , "Morning", "Evening")

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[Anonymous]

Hi @harshnathani 

Thank you, you put me on the right track.

It is probably related to my region but I replaced the "," by ";" for the hours "5;0;0"

Now I try to add a 3rd  and last condition to my column 

- "Morning" between 05:00 and 13:00

- "Evening" between 13:01 and 21:00

- "Night" between 21:01 and 04:59

but is impossible with the IF command (only 2 arguments).

I find a lot of information on IF ELSE.
I can't do it but I'm working on it 🙂

have a nice day

[harshnathani]

Hi @Anonymous 

Try this.

Column =

IF (

Table15[Time] >= TIME ( 5, 0, 0 )

&& Table15[Time] < TIME ( 12, 59, 0 ),

"Morning",

IF (

Table15[Time] >= TIME ( 13, 0, 0 )

&& Table15[Time] < TIME ( 21, 0, 0 ),

"Afternoon",

"Night"

)

)

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[Anonymous]

it works very well @harshnathani 

Thank you very much for your precious help, it makes me want to go even further.

I validate the first solution because it answers the original subject.

regards,

Bastien