I had to do something like this recently so hopefully this can help...

go to custom number field and change one of them to this:
##":"##" P.M.";[Red]##":"##" A.M."

Then you can enter A.M. and P.M. using positive and negative numbers
and no colon.

For instance: 0808 = 8:08 p.m.
while: -0808 = 8:08 a.m (in red)

Change the formating as you need.

Josh


--
streetboarder
------------------------------------------------------------------------
streetboarder's Profile: http://www.excelforum.com/member.php...o&userid=30707
View this thread: http://www.excelforum.com/showthread...hreadid=511135