Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Convert minutes to HH:MM - Calculated column

I have a field in Power BI which gives me the minutes number.   Example :- 14    I need to convert it to the format HH:MM. Please help   Examples    -- 14 need to be changed as 00:14 -- 62 n...
Need Help
Show and Tell
  • Samarth_18's avatar
    Samarth_18
    5 years ago

    HI Anonymous 

    you can create a column with below code:-

     

    In Hours and Minutes = 
var _Minues='Convert HHM'[Column1]
var _Hours=int( _Minues/60)
var _RemMinutes=MOD(_Minues, 60)
return
  _Hours&":"&IF(_RemMinutes< 10,"0"&_RemMinutes,_RemMinutes)

     

    Thanks,

    Samarth

Samarth_18's avatar
Samarth_18
Icon for Community Champion rankCommunity Champion
5 years ago

HI Anonymous 

you can create a column with below code:-

 

In Hours and Minutes = 
var _Minues='Convert HHM'[Column1]
var _Hours=int( _Minues/60)
var _RemMinutes=MOD(_Minues, 60)
return
  _Hours&":"&IF(_RemMinutes< 10,"0"&_RemMinutes,_RemMinutes)

 

Thanks,

Samarth

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi,

 

Unsure what I have done incorrectly, it does not pick up the column name "Loading TAT(mins)"