DAX

[koorosh]

Hi All,
What is the DAX formula for a visual card that shows 11.45 as 11 hours and 45 minutes and shows 11.70 as 12 hours and 10 minutes?

[lbendlin]

One thing is for sure - with this cavalier attitude to time formats you won't be on Santa's Nice list.

[Ahmedx]

pls try this

[koorosh]

Hi Ahmed and Ibendin,

The following table shows the daily work hours for a person. I want to show in a visual card how many hours and how many minutes the person worked. For instance 45 hours and 20 minutes.

 

[Ahmedx]

you explain where you got 45 hours and 20 minutes

[koorosh]

I want on visual card written "25 hours and 35" minutes.

[lbendlin]

You need to use the same approach. Add the fractions separately from the integers.   Mod the fractions by 60.