Military Time:Is there a formula that would easily convert it?

I am trying to convert cells containing military time to regular time. Ex.
1430 to 2:30. Is there a formula that would easily convert it? Thanks!

http://www.cpearson.com/excel/DateTimeEntry.htm

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Sue" <[email protected]> wrote in message
news:[email protected]...
>I am trying to convert cells containing military time to regular time. Ex.
> 1430 to 2:30. Is there a formula that would easily convert it? Thanks!

One way:

=TIME(INT(A1/100),MOD(A1,100),0)

In article <[email protected]>,
Sue <[email protected]> wrote:

> I am trying to convert cells containing military time to regular time. Ex.
> 1430 to 2:30. Is there a formula that would easily convert it? Thanks!