changing format
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! |
changing format
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! |
All times are GMT +1. The time now is 06:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com