Duration column is not coming properly in the Power BI

[bourne2000]

Hi

My data source in google sheet and my data column like talk time

However, when I tried to connect to Power BI, I am getting this error. I tried to format the column in google sheet into duration and text but had no success

this is my original data in the google sheet

Error in Power BI

Please advise

[smpa01]

@bourne2000  I think you need to create a duplicate column in Google Sheet that would be a text version of

[Wrap Up Time] and then you are going to get the text version of that column

[mahoneypat · Accepted solution]

One way to do that would be to convert that column to text type, and then add a custom column with this expression (returns days in decimal form). From there, convert that new column to decimal and load it. See this article for best practices on how to deal with durations from there.

Calculate and Format Durations in DAX – Hoosier BI

= let
inputlist = Text.Split([Duration], ":"),
numberlist = List.Transform(inputlist, each Number.FromText(_)),
minutes = numberlist{0} * 60 + numberlist{1} + numberlist{2}/60
in
minutes/(60*24)