Excel Data has time formatted converts to decimal in Power BI want it to match Excel

[inglexjc]

My data that's coming from Excel comes in correctly. The Average Handle time ect comes in how I want it.

But when I have it go to Power BI the format changes to Decimal Number.

And simply changing the Data Type to TIME is not giving the correct Time.  Should be minutes not an acutail time.

How do I get PowerBI to show exactly what Excel is brining over?

[jgeddes · Accepted solution]

It is in the Transform Data (Power Query) portion.

click the 'ABC' or whetever icon is in that position and select duration

[jgeddes]

Using the duration type instead of the time type may get you the result you are looking for.

[inglexjc]

Where would I find that option?