Thread
:
Military Time
View Single Post
#
4
Posted to microsoft.public.excel.misc
Gary L Brown
Posts: n/a
Military Time
I can't think of a way except via macro but you could use a formula in B1
formated the way you want...
=TIMEVALUE(LEFT(A1,LEN(A1)-2)&":"&RIGHT(A1,2))
HTH,
--
Gary Brown
If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.
"exsam21" wrote:
Is it possible for me to enter "1353" in cell A1 and it will
automatically display 1:53PM in cell A1? This would help a bunch.
Thanks.
--
exsam21
------------------------------------------------------------------------
exsam21's Profile:
http://www.excelforum.com/member.php...o&userid=22666
View this thread:
http://www.excelforum.com/showthread...hreadid=502566
Reply With Quote