Hi

Enter the number 60 into some free cell and copy it.
Select the range with your data, and then PasteSpecialMultiply. OK.
Format rhe range as "mm:ss".
Don't forget to scrap the number 60 entered before.


--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )


"HMB" wrote in message
...
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