ExcelBanter - convert standard number to time format

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

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

- - convert standard number to time format (https://www.excelbanter.com/excel-worksheet-functions/140671-convert-standard-number-time-format.html)

TEA

convert standard number to time format

I have a customer that whats to be able to enter time as military time 2123
w/no colons and it would be converted to a normal time format 9:23 PM

T. Valko

convert standard number to time format

See this:

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

Biff

"TEA" wrote in message
...
I have a customer that whats to be able to enter time as military time 2123
w/no colons and it would be converted to a normal time format 9:23 PM

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