Quote:
Originally Posted by
I have 2 times:
A) 4:12:31 PM
B) 4:07:45 PM
In a cell I have the formula (TimeB - TimeA). The cell displays a strange number as a result - 23:55:14. I was hoping it would display the actual time difference (negative or positive).
Is that possible ?
Thanks in advance.
|
This looks correct for what you are asking. Thinking in pure math terms, you are subtracting a large number from a smaller one which will always return a negative number. To get the difference between the two times, you need to subtract the start time (4:07:45) from the end time (4:12:31).