Time format is not matching

[rlama]

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 someone please advise and help.

Thank you for your usual help.

[Nathaniel_C]

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

[rlama]

@Nathaniel_C thank you for the response but when I am trying to change it as duration it is giving me an error. 

[Anonymous]

@rlamaSo, you are changing it to smallest unit? For example, 00:10:10 to 70s(seconds)?