If you right-click on a cell you can access custom formats via the format
cells option.

Just enter h:mm and it returns 24 hour time.
--
Brevity is the soul of wit.


"kcain" wrote:


I noticed above that you said you changed the format to h:mm. How did
you change the format to time?

Thanks,
KCain

http://www.excelsecrets.com/photoshop/index.php


--
kcain
------------------------------------------------------------------------
kcain's Profile: http://www.excelforum.com/member.php...o&userid=37907
View this thread: http://www.excelforum.com/showthread...hreadid=574323