cancel
Showing results for
Did you mean:
Frequent Visitor

## 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))

1 ACCEPTED SOLUTION
Community Support

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 2
Community Support

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.

Frequent Visitor

ThanksEyelyn Qin

Announcements

#### 2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

#### Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

#### Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Top Kudoed Authors