Forum Discussion
Time format is not matching
Hi all, Just struggling for below. I have a excel spreadsheet report where I have total hours value for each topics but when I am exporting it to Power BI it is giving me a different values. Can som...
Hi rlama
You need to mark it as duration, not time. Either in Excel or Power Query. It seems to be a little bit touch.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
25 Use format d "days" h:mm:ss or [h]:mm:ss, depending on your needs. Say you have a duration of 30h 12m 54s: [h]:mm:ss -> 30:12:54 d "days" h:mm:ss -> 1 days 6:12:54
Nathaniel_C thank you for the response but when I am trying to change it as duration it is giving me an error.
rlamaSo, you are changing it to smallest unit? For example, 00:10:10 to 70s(seconds)?
