Turning whole number into time passed

[Hgsilva]

I have a whole number column that represents minutes taken to complete a step. When I try to convert this number into a time format (e.g., 90 minutes = 1 hour 30 minutes) I get the following error. Am I doing it wrong or do I have too much data in this and will need to find a different way to do it?

[lbendlin]

Divide your number by 1440 and then use regular date/time formatting.

[Ritaf1983]

Hi @Hgsilva 
Please use the DAX formula :

Time_format =

Var hours = QUOTIENT('time table'[Time],60)

Var minutes = MOD('time table'[Time],60)

RETURN

TIME(hours,minutes,0)

and time format

The pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[Hgsilva]

Hi @Ritaf1983 ,

Unfortunately I receive the same error with this formula. 

[lbendlin · Accepted solution]