Hans,

I only needed the format to display on the screen and for report
printing purposes. I haven't needed to do any formulas based on the
cells and I was assuming it isn't possible the way i have it set up.

Maybe some others have better ways of doing it and keeping the time
format?

Josh


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