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