Separating time interval elements(hh:mm:ss) recorded in single col into separate cols

oldwiring

Durations of events are recorded in a single column formatted hh:mm:ss.
I want the three elements: hh, mm.ss to be placed in individual columns.
I have tried Text to Columns, but all that does is to ocerwrite the original column with
00:00:00 and add two more columns with 00:00:00.
In the Text to Columns process I am using Delimited with the colons as the delimiters

I must be doing something wrong, but am head scratching what it is.

Help please!

CLAPTON

maybe I'm not understanding you

but if say c3 = 10:30:05

then =HOUR(c3) give 10
=minute(c3) gives 30
=second (c3 ) gives 5

Lil306

oldwiring wrote: »

Durations of events are recorded in a single column formatted hh:mm:ss.
I want the three elements: hh, mm.ss to be placed in individual columns.
I have tried Text to Columns, but all that does is to ocerwrite the original column with
00:00:00 and add two more columns with 00:00:00.
In the Text to Columns process I am using Delimited with the colons as the delimiters

I must be doing something wrong, but am head scratching what it is.

Help please!

I think you're on the right track. How about text - columns. Then apply a custom cell properties to each field.

I.e Column A, custom time of HH, Column B, custom time of MM, Column C with SS with no decimal places. Or something like that

Excel isn't really my forte but text to columns is the first thing I thought of too

oldwiring

:beer:Clapton's suggestion works. I'll see if Lil306's does too.