Convert Hours:Minutes:Seconds to Minutes in Power BI

[Anonymous]

Hi Experts

How could you convert 08:30:00 into minutes as a column in a table. So if a employee has workd 08 hr  and 30 minutes and zero seconds i want to show this as minutes only (calculated column)

[sevenhills]

Check this article: https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Duration-to-Seconds-Converter/m-p/3...
You can adjust the formula to convert into minutes

[Ahmedx · Accepted solution]

what do you want this

or that

[rsbin]

@Anonymous ,

There are a number of ways this can be done.  Here is one solution:

Duration_Minutes = 
VAR _Hours = VALUE(( LEFT( [Duration], 2 ) * 60 ))
VAR _Minutes = VALUE( MID( [Duration], 4,2))
VAR _Seconds = VALUE(RIGHT( [Duration], 2)/ 60 )
RETURN
    _Hours + _Minutes + _Seconds

Assumes all of your Duration is the exact format xx:yy:zz

Hope this helps.

Regards,