Negative time values??
Posted by Todd Norbury on May 05, 2001 9:03 PM
was just wondering if it is possible to have excel 97 show negative time values.
I have put together a spreadsheet for a few mates so as we can track our racing times. At the moment, we are all aiming for a certian time that is stored in B19. Our times are in C19-H19. I have to use the formula below to get it to output any time at all.
If I just have B19-H19 and the result is negative, I get an error.
I have a custom time format of m:ss.000
Any help would be greatly appreciated, more so if you could email me your answers.