Forum Discussion
Solved
Turning whole number into time passed
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. A...
Ritaf1983
Super User
Super UserHi 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
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.
