That is because negative time is an anachronism.

If it is caused by time straddling midnight, just add 1 to the result to get
the true hours elapsed.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"John Sheakley" wrote in message
om...
Negative dates or times are displayed as ####. The cell retains the
negative value. How can I display negative time as "h:mm AM/PM" in red or
with a negative sign? The cell should retain the negative value.