ExcelBanter - Converting Times

On Aug 18, 11:48*am, "Dave" wrote:
Hi

I've been trying to change these, yet can't figure how to do it

The column is formatted in General

59.22s * * * * * to * *00.59.22

1m 31.58s * * *to * *01.31.58

Thanks in advance

Dave

Dave,

Take a look at the Format Cells Dialog (Ctrl + 1). In the "Number"
tab you'll see "Time" under the category. Look through this to get an
idea you how you can format your number as time. If you don't find
something you like within the "Time" category then go to "Custom" and
create your own. If your cell is a text string (i.e. it truly states
59.22s - numbers and text), then this will be a different issue
because you'll need to transform your data a bit before you can get it
to the desired format (which won't be difficult because Excel's built
in formulas make that pretty easy; however, if you want to do math on
the cells then that's yet again a separate issue).

Best,

Matthew Herbert