Time stored as text. How can I convert to data and time?

Hi, I thought I could do this...but it's driving me bananas!

I've have a column of a report that's for telephone call duration, but the information is left aligned/text.

Is there a formula I could use to convert this to data?

Thanks in advance.

Matthew


Duration
0:00:45
0:02:16
0:00:19
0:06:31
0:05:50
0:04:03
0:04:30
0:02:17
0:27:45
0:06:41
0:00:26
0:00:52
0:00:38
0:00:55
0:02:21
0:04:14
0:05:10
0:02:15
0:02:16
0:01:27
0:10:18
0:01:24
0:08:24
0:04:14
0:00:21
0:00:38
0:00:26
0:00:53
0:17:01

Select the column
Data ribbon - text to columns - Finish

Hi Arthur,

First of all, thank you!

I'd tried that route, but then became flummoxed because I had my minutes data in one column and seconds in the next..I'm still flummoxed to be honest.

It looks like this:

Duration
0 0 45
0 2 16
0 0 19
0 6 31
0 5 50
0 4 3
0 4 30
0 2 17
0 27 45

How can I get it so instead that date is in one column, like this:

00:00:45
00:02:16
00:00:19
etc

Thank again,

Matthew.

That is why posting a sheet is much easier...

Anyway try =(a1&":"&a2&":"&a3)*1

To you both, thank you. In future I will include sheets, I can see how this makes more sense, sorry.

I've just tried the text to columns method again. I (idiot) used a colon as the delimiter and that's why it separated out.

But I've just tried the straight highlight column > data ribbon > text to columns > finish (without pressing next) and the text seems to remain as text, left aligned and I can't use it to sum etc. Any ideas?

Thanks.

Boom! I'm on my way. Many thanks for your help folks!