Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
daniel_leite
New Member

Negative time / working hours

Hi. 

I'm using data from an Excel file that is about hours of work that is like: 

daniel_leite_0-1691697017551.png


In the first column from the source file I have this negative hours that I need to use, but when I use it on Power BI it changes the negative hours within the left column to a date and hour totally different from the original values

daniel_leite_2-1691697374820.png

 

Does anyone have any ideia about how to fix it? Because I need to use it as it was, with the negative values to create the metrics 

3 REPLIES 3
Idrissshatila
Super User
Super User

Hello @daniel_leite , 

 

so I tried to go through the Process you did,

 

first I added a sample of negative fields in an excel sheet and marked the column as time

 

Idrissshatila_0-1691700081598.png

 

 

Then in Power Query I adjusted the column type as Text

Idrissshatila_1-1691700193321.png

 

Then loaded the data

Idrissshatila_2-1691700219343.png

 

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Thank you so much for your kind help. 
I found that the negative values have a strange format. The -05:58:00 hour has the value =-"05:58:00" inside the cell. So when I try simply to exclude or substitute values like =-" or :00" it gives me an error because Excel understand it as a formula. So now I trying to figure out how to exclude it in fact.
Your reply gave me an idea about how to fix it. Thanks for your help! 

Hello @daniel_leite ,

 

yes, to out run this error insert  a " ' " before the negative sign -

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.