Problem with time in excel

[patrickrock]

Hello,

I am opening up a spreadsheet generated by BCMS (phone switch reporting
software).

All of the time is in the following format:

00:00 (mm:ss)

example 00:03 (equal to 0minutes 3 seconds)

(I think part of the problem may be that it always minutes seconds so
4000 minutes and 30 seconds would be 4,000:30)

However excel doesn't seem to want to interpret this correctly and will
not let me format it correctly, nor will it convert it to a serial
number correctly.

However, if I do something like:

=(A1*24)*60) then I wind up with a number equal to the seconds being
expressed.

so using my example I get 3.

is there some way that I can apply that calculation to those cells
without having to create a seperate column?

 

[Bob Phillips]

put 1440 in a cell, then copy it

Select all of your time cells

Then Edit>Pastespecial and in the Operation section, pick the Multiply
button

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[patrickrock]

damn I love this internet thingy

Thanks very much for the help