| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Text numbers to time format
I have numbers (time) imported as text so I cannot simply format the cell to time. does anybody know a formula that will convert this to the following 130702 - to - 01:07:02 PM 093506 - to - 09:03:06 AM 101607 - to - 10:16:07 AM 123958 - to - 12:39:58 AM 225409 - to - 10:54:09 PM -- jermsalerms ------------------------------------------------------------------------ jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167 View this thread: http://www.excelforum.com/showthread...hreadid=503133 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert Text numbers to time format
=TIME(LEFT(A1,2),MID(A1,3,2),RIGHT(A1,2))
and copy the formula down, then format all cells as hh:mm:ss AM/PM -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "jermsalerms" wrote in message ... I have numbers (time) imported as text so I cannot simply format the cell to time. does anybody know a formula that will convert this to the following 130702 - to - 01:07:02 PM 093506 - to - 09:03:06 AM 101607 - to - 10:16:07 AM 123958 - to - 12:39:58 AM 225409 - to - 10:54:09 PM -- jermsalerms ------------------------------------------------------------------------ jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167 View this thread: http://www.excelforum.com/showthread...hreadid=503133 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert Text numbers to time format
Try this formula =TEXT(A1,"00\:00\:00")+0 -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=503133 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert Text numbers to time format
I tried Bob's 1st and it worked so Im sticking with it. I sure the other one works well too -- jermsalerms ------------------------------------------------------------------------ jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167 View this thread: http://www.excelforum.com/showthread...hreadid=503133 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert text to numbers | Excel Discussion (Misc queries) | |||
| convert numbers to text | Excel Discussion (Misc queries) | |||
| convert number to time format? | Excel Discussion (Misc queries) | |||
| How do you convert numbers as "text" to values for a long column . | Excel Discussion (Misc queries) | |||
| how to format numbers stored as text or vice versa to use vlookup | Excel Worksheet Functions | |||
Linear Mode
