Saturday, 03 February 2018
  0 Replies
  5K Visits
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.
There are no replies made for this post yet.