Displaying negative time in excel
1904 date system.
--
David Biddulph
"Six Sigma Blackbelt" wrote in
message ...
I have a worksheet that displays appt. time & actual time in, some of my
actual time in data is greater than the appt. time ex: 13:15 appt time,
Actual time in 13:18, the cell should show :03 in red? but instead it
gives
me a #VALUE!. How can I display this time, and show it as a negative time.
|