Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Negative time data from excel not showing correctly

Hello everyone,    I have a column from excel  with time variance data, however when I upload this data into PowerBI and select to show it in time format hh:mm:ss, it only shows the positive times ...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi Anonymous,

     

    I think the negative value couldn't be a valid time value. Actually we can say it's a duration type. How about counting them as TEXT? Can you share a sample? I can't convert a negative value in my test.

     

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous,

 

I think the negative value couldn't be a valid time value. Actually we can say it's a duration type. How about counting them as TEXT? Can you share a sample? I can't convert a negative value in my test.

 

Best Regards,

Dale

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I actually tried this too, but after you transform the time to text. You can no longer sum the time in form of time. Do you have an idea how to sum times also including negative times?