Excel does not display negative time. So if you are working with negative times, there is a problem. Fortunately, there are ways to work around this issue.
This tutorial will show two ways to display a negative time in Excel.
For this example, we have the fastest times for the last six London Marathons for the men’s category. And we want to see the time difference compared to the previous year.
If the time is faster than the previous year, the result will be a negative time. A slower time would return a positive time.
[Read more…] about Display Negative Time in Excel