Forum Discussion
Negative time / working hours
Hi. I'm using data from an Excel file that is about hours of work that is like: In the first column from the source file I have this negative hours that I need to use, but when I use it o...
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 👍