ExcelBanter - Military Time

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Military Time (https://www.excelbanter.com/excel-worksheet-functions/24461-military-time.html)

Sue

Military Time

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!

Niek Otten

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Sue" wrote in message
...
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!

JE McGimpsey

One way:

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

In article ,
Sue 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!

All times are GMT +1. The time now is 09:00 AM.