In Excel XP, the first time format is listed as "*1:30:55 PM" in the
Time category and "[$-409]h:mm AM/PM;@" in the Custom category. It does
not show the sign for negative times in the 1904 date system. All other
time formats do show the sign (I never use the 1904 system in practice,
and got snookered by it being the first one, sorry). Interestingly,
that custom format in Excel 2000 does display the sign on negative
times. I don't have access to Excel 2003 tonight to see what it does.

Jerry

JE McGimpsey wrote:

In MacXL, -1/24 displays as -1:00:00 AM.

Is this a bug in WinXL?


In article ,
"Jerry W. Lewis" wrote:


It also has the potential to cause confusion, since 1/24 and -1/24 are
both displayed as 1:00:00 AM (i.e. there is no formatted indication that
the time is negative).