Skip to main content
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Saturday, 03 February 2018
  0 Replies
  4.8K 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.