I have problems subtracting hours from hours.
If I subtract 01:00 from 01:00 , the result is negative -00:00. This makes formatting rule look negative because I want it to turn green when my result averages to 00:00.
The number -5,55112E-17 is a general formatted value of the result -00:00.
I have searched a lot for a solution, but all google gives me is the solution for calculating negative time with the 1904 date system.
I hope someone can help me with a solution or work-around of my problem.
If I subtract 01:00 from 01:00 , the result is negative -00:00. This makes formatting rule look negative because I want it to turn green when my result averages to 00:00.
The number -5,55112E-17 is a general formatted value of the result -00:00.
I have searched a lot for a solution, but all google gives me is the solution for calculating negative time with the 1904 date system.
I hope someone can help me with a solution or work-around of my problem.