Forum Discussion

Basheer24's avatar
Basheer24
Frequent Visitor
5 years ago
Solved

Convert hours on PowerBI

Dear all,

 

I'm not an expert on PowerBI and need some help. How can I get the below formula into power BI.

 

=VALUE(LEFT(TEXT(A2,"##0.00"),FIND(".",TEXT(A2,"#0.00"))-1)*60)+VALUE(RIGHT(TEXT(A2,"#0.00"),2))

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Basheer24 ,

     

    If the column is Number type, you could use the following formula to create a column:

    Column 1= 
var _Integer= INT([Contract(hh.mm)])
var _Decimal= ([Contract(hh.mm)]-_Integer) *100
return _Integer *60 + _Decimal

     Or modify your syntax to fit in PBI like this:

    Column 2= 
var _s=FORMAT([Contract(hh.mm)],"##.00")
return LEFT( _s ,FIND(".",_s)-1) * 60 + RIGHT(_s,2)

    The final output is shown below:

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Basheer24 ,

     

    If the column is Number type, you could use the following formula to create a column:

    Column 1= 
var _Integer= INT([Contract(hh.mm)])
var _Decimal= ([Contract(hh.mm)]-_Integer) *100
return _Integer *60 + _Decimal

     Or modify your syntax to fit in PBI like this:

    Column 2= 
var _s=FORMAT([Contract(hh.mm)],"##.00")
return LEFT( _s ,FIND(".",_s)-1) * 60 + RIGHT(_s,2)

    The final output is shown below:

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.