Need to calculate the average time in Power BI

[riyaspbi]

1. The time duration is 1:47 but after it gets loaded into Power BI, the data showing as 0.0743055555555556. It is very difficult convert the data into duration formation which need to arrive the average time we spent.

2. The time duration is 00:01:47 but after  it gets loaded into Power BI, the data showing as 12/31/1899 1:47:00 AM. It is very difficult convert the data into duration formation which need to arrive the average time we spent.

I tried to do formatting the either 1:47 or 01:47:00 but unable to to that.

Need your help to fix this.

[v-juanli-msft]

Hi   @riyaspbi

Do you import data from excel?

When I import from excel, 1:47 ->1:47:00, 00:01:47->12/31/1899 12:01:47 AM, Then I can use DateTime.Time function to extract only time value.

Best Regards

Maggie