| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
convert number to time format?
I have a column of 3-4 numbers representing time of day. The number vary from 63 (=6:30 AM) to 113 (= 11:30 AM). Can anyone help me to convert the numbers to time format? Thanks. -- JLHORMAN ------------------------------------------------------------------------ JLHORMAN's Profile: http://www.excelforum.com/member.php...o&userid=23768 View this thread: http://www.excelforum.com/showthread...hreadid=374148 |
|
#2
|
|||
|
|||
|
Assumption: Cell D7 contains your coded time (e.g. 63 or 113) Use this formula in a cell formatted as TIME 1:30 PM: =(LEFT(D7,LEN(D7)-1)&":"&RIGHT(D7,1)&"0")*1 The result is 63 becomes 6:30 AM 113 becomes 11:30 AM NOTES: times from midnight to 12:50 AM will need to be entered as text in this format: '00 =12:00 AM '03 = 12:30 AM 123 = 12:30 PM 133 = 1:30 PM 233 = 11:30 PM HTH -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=374148 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time format help needed | Excel Worksheet Functions | |||
| why does currency format change to number format? | Excel Discussion (Misc queries) | |||
| Convert time to all seconds | Excel Discussion (Misc queries) | |||
| How do I convert time format to text? | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
