Military Time

E

exsam21

Is it possible for me to enter "1353" in cell A1 and it wil
automatically display 1:53PM in cell A1? This would help a bunch.
Thanks
 
G

Gary L Brown

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,
 
Top