Music durations

[Heydiddle]

I am copying working with CD metadata and coming across a problem with durations. What is supplied to me is this format 0:00 and I need it to be 00:00. But every time I try to either manually change it or use custom mm:ss it comes out as a totally different number. Know this has something to do with the serial number.... Can someone help me figure this dilemma out? I have thousands of CDs to do for a publisher. Thanks!

 

[nuked]

try custom nn:ss

 

[Heydiddle]

that is not an option in custom. mm:ss is but it does not work....changes number completely. any other suggestions?

 

[Scott Huish]

Try:

hh:mm

 

[Heydiddle]

that is not an option in the custom selection either

 

[Jonmo1]

that is not an option in the custom selection either

Type it manually by hand.

 

[Heydiddle]

not an option....thousands upon thousands of tracks to transfer data on.

 

[Jonmo1]

Highlight the ENTIRE range that contains the durations
Foramt - Cells - Number - Custom
type in
hh:mm

 

[Heydiddle]

Thank you!!

 

[Heydiddle]

That worked for 2:54 but Oh wait what if they are 00:02:54 and I need them 02:54??

THanks all.