I have a large spreadsheet listing details of telephone calls and their
details. It goes:

Caller : Number : Date : Duration

The Duration column is text, and is in minutes.seconds, ie 90 seconds is
1.30.

How can I set up a way of converting all these cells to just plain seconds
format? I have entered in phone calls as they appear on the bills, and now
I want to do some meaningful statistical work on the data and discovered I
did things stupidly.

I have many hundreds of cells so a way of setting up a formula or filter to
do it automatically would be what I want. I have no idea how to do this!

Can anyone help? Many thanks!

Hi John,

Try f custom ormatting the cells as [ss]


---
Regards,
Norman



"John" wrote in message
...
I have a large spreadsheet listing details of telephone calls and their
details. It goes:

Caller : Number : Date : Duration

The Duration column is text, and is in minutes.seconds, ie 90 seconds is
1.30.

How can I set up a way of converting all these cells to just plain seconds
format? I have entered in phone calls as they appear on the bills, and
now
I want to do some meaningful statistical work on the data and discovered I
did things stupidly.

I have many hundreds of cells so a way of setting up a formula or filter
to
do it automatically would be what I want. I have no idea how to do this!

Can anyone help? Many thanks!