Times

[Chris]

I have an MP3 tag program that exports a list of my MP3's to excel which
includes the time for each song.
The cell format in the exported file is set to general but I need to have
the time entered as [m]:ss so I can total a the time for a number of songs
in a cell (with a [h]:mm:ss format) to get a total time which may be over 1
hour.
The only way I can seem to do this is by changing the cell format from
general to [m]:ss and placing a 0: in front of the time that has already
been entered as 04:39, but with over 2000 songs this could take quite a
while.
Does anyone know if there is an easy way to put the 0: in front of the time
that is already there?

thanks.
Chris.

 

[Norman Harker]

Hi Chris!

Put 60 in a cell
Copy
Select the cells with times in them
Edit > Paste Special > Divide > OK
Format Time [mm]:ss

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)

It is imperative that the patches provided by Microsoft in its April
Security Release be applied to Systems as soon as possible. It is
believed that the likelihood of a worm being released SOON that
exploits one of the vulnerabilities addressed by these patches is VERY
HIGH.
See:
http://www.microsoft.com/security/protect/