Export to Excel hh:mm column

[Syndicate_Admin]

Hello

Does it happen to anyone that when you export a Power BI table that contains a column in HH:MM time format, it doesn't export correctly?

When I switch to excel, the entire time column is modified by negative numbers

Examples:

17h pm puts it in Excel as -53323,7083333333

9 am puts it in Excel as -53323,375

So it goes with every hour.

Thank you.

[Anonymous]

Hi @Syndicate_Admin ,It's glad to hear that your problem has been resolved.It will help the others in the community find the solution easily if they face the same problem as yours.  Thank you.

[Syndicate_Admin · Accepted solution]

I solved it by adding a new custom column and just taking the time, then I formatted text to the column and it exports it well, I don't know if it's the right way but it works.