I think you mean
PasteSpecial>Divide

HTH. best wishes Harald

"Arvi Laanemets" <garbage@hot.ee> skrev i melding
news:O7eNRKnvFHA.720@TK2MSFTNGP15.phx.gbl...
> Hi
>
> Enter the number 60 into some free cell and copy it.
> Select the range with your data, and then PasteSpecial>Multiply. OK.
> Format rhe range as "mm:ss".
> Don't forget to scrap the number 60 entered before.
>
>
> --
> Arvi Laanemets
> ( My real mail address: arvil<at>tarkon.ee )
>
>
> "HMB" <HMB@discussions.microsoft.com> wrote in message
> news:0341A574-1AF7-4D0B-B52F-ABF5E9DFD75E@microsoft.com...
>>I have scanned a telephone account which shows the duration of a call as
>> min:sec (eg.15:35). Using an OCR program I have imported this data into
>> Excel which picks the time up as hh:mm format. is there anyway to get
>> Excel
>> to read it as minutes and seconds instead of hours and minutes without
>> going
>> thru every record and adding a 0: (to hold the hour place)???
>>
>> Thanks
>>
>> Helen
>
>