Forum Discussion

rlama's avatar
rlama
Regular Visitor
6 years ago

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

 

Thank you for your usual help.

 

Need Help

3 Replies

  • Nathaniel_C's avatar
    Nathaniel_C
    Community Champion
    6 years ago

    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's avatar
      rlama
      Regular Visitor
      6 years ago

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

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