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!
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" <Sue@discussions.microsoft.com> wrote in message
news:369994CD-A309-42F4-BF75-517374EE301E@microsoft.com...
>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 <369994CD-A309-42F4-BF75-517374EE301E@microsoft.com>,
Sue <Sue@discussions.microsoft.com> 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!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks