Skip to main content
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
  Saturday, 03 February 2018
  0 Replies
  4.9K Visits
0
Votes
Undo
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.

Excel.PNG

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.