|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
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
|