Convert data into proper time format

's Computer Specifications

26:47:00 -> 1/1/1900 2:47:00 AM
:00 -> :00
12:49 -> 12:49:00 PM
:00:00 -> :00:00
1:15 -> 1:15:00 AM
:11 -> :11

I have the above data in A1:A6. Text written next to "->" is how it is
shown in the formula bar. I want to convert it into [hh]:mm:ss format.

The result I want in B1:B6 is show below. How can I convert?

26:47:00
00:00:00
00:12:49
00:00:00
00:01:15
00:11:00

's Computer Specifications

You'll have to change the values that begin with : to 0:
Then format Cells->Time -> 37:30:55

"(E-Mail Removed)" wrote:

> 26:47:00 -> 1/1/1900 2:47:00 AM
> :00 -> :00
> 12:49 -> 12:49:00 PM
> :00:00 -> :00:00
> 1:15 -> 1:15:00 AM
> :11 -> :11
>
> I have the above data in A1:A6. Text written next to "->" is how it is
> shown in the formula bar. I want to convert it into [hh]:mm:ss format.
>
> The result I want in B1:B6 is show below. How can I convert?
>
> 26:47:00
> 00:00:00
> 00:12:49
> 00:00:00
> 00:01:15
> 00:11:00
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to convert data in rows to columns like time series format	=?Utf-8?B?QXJlbmRlbg==?=	Microsoft Access Queries	1	17th Apr 2007 03:52 AM
Import csv data and convert to TIME format	JLettington	Microsoft Excel Worksheet Functions	0	25th Jan 2006 03:34 PM
Convert data into standard military time format	=?Utf-8?B?Z2VvZw==?=	Microsoft Excel Misc	2	12th Dec 2005 07:46 PM
convert Access data stored in in time format (GMT) to EST	=?Utf-8?B?VEpOQzk0Njk=?=	Microsoft Access Reports	2	23rd Mar 2005 06:25 PM
How do I convert spreadsheet into proper format?	=?Utf-8?B?Z3VydW5uZXI=?=	Microsoft Excel Misc	3	24th Nov 2004 12:13 AM