data in excel is time duration but when I load to power BI it changes to date/time

[Anonymous]

My excel data is in time duration but when I load to Power BI/query it all converts to date/time - how can I fix this? I need to show the total login time of call center agents...

[ray_ux · Accepted solution]

on the power query editor, you should be able to change data type as it's currently registered as date. Or you can also delimiter and keep the time, both ways work.

[Anonymous]

thanks for the response - not sure what "Or you can also delimiter and keep the time" means - sorry super newbie 🙄

[ray_ux]

https://docs.microsoft.com/en-us/power-query/split-columns-delimiter