Times

C

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.
 
N

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
[email protected]

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/
 
J

jtnyc

I got the UTC time convertion to work, but only can get the tim
displayed correctly.

used this format: h:mm:ss

I would also like to display the date as well. when i used the forma
for date and time it just give me some like this:
#############

Can anyone help me on this
 
D

Dave Peterson

The thread for this message has disappeared off my newsreader's cache. So this
might not be anywhere close to what you need, but if your columnwidth is too
skinny, then you can see ###'s for date/time cells.

You can also get this with negative time/date (in 12/31/1899 date system).
 
Top