| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hour and minute
I need to add a colon to military time. I don't want am/pm to show. Only
change for example 1730 to 17:30. How do I do this? "Bob Phillips" wrote: =TIME(INT(A1/100), MOD(A1,100),0) -- HTH RP "Vincdc" wrote in message ... Hello: I have some data like 415, 537, 2012... Which function I can use to convert this number to hh:mm format, e.g. 4:15, 5:37 and 20:12? Thanks in advance! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Question on Format in Hour & Minute | Excel Worksheet Functions | |||
| Hour and minute | Excel Worksheet Functions | |||
| Formula for Hour Minute and Second | Excel Worksheet Functions | |||
| convert time from 60 minute hour to 100 minute hour | Excel Discussion (Misc queries) | |||
| convert 100 minute hour to a 60 minute hour | Excel Worksheet Functions | |||
Linear Mode
