This formula will return the time value of a three digit or four digit
number in military time format without having to enter ( : ) between
the numbers.

Will also accommodate for entering time by pressing, ( Ctrl + Shift + ;
).

=IF(LEN(A1)=3,TIME(LEFT(A1,1),RIGHT(A1,2),0),IF(LE N(A1)=4,TIME(LEFT(A1,2),RIGHT(A1,2),0),A1))


--
Flintstone
------------------------------------------------------------------------
Flintstone's Profile: http://www.excelforum.com/member.php...o&userid=15310
View this thread: http://www.excelforum.com/showthread...hreadid=385602