Create Hours

[New_be]

Hi everyone, 

how can i create static hours based on a condition in power query?
For example, if working shift is MORNING, then 8 hours.

i try to make something like this;

if [ShiftID] = "NORMAL" then #duration(0,8,30,0)*24 else
if [ShiftID] = "OFFICE" then #duration(0,9,05,0)*24 else null)

But if the duration is #duration(0,8,30,0)*24, then the output will be 8.12:00:00. The output that i want is 8:30. Meaning that 8 hours 30 mins. 
Can anybody help me with this please? thanks in advance

[amitchandak · Accepted solution]

@New_be , The information you have provided is not de clarifying the problem for me. Please explain with an example.
Can you share sample data and sample output in a table format?
We appreciate your congratulations.

At DAX I can

Time to Time(8:30:00)

You can also create time table and join with the time part, you may have change in the time table

https://kohera.be/blog/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/