Duration problem

G

geewhizza

Recently to avoid cd buying duplication i started to create a excel
database of my audio cd collection , artist, track,cd name, duration of each
track etc.

I am now about half the way through my cd database and have just started
using a little program that gets me the track info from gracenote which i
then copy and paste into excel the problem is...

The track duration isnt copying the same as it is being displayed for
example this is how it should be

M People - Moving On Up - Funky Divas cd 2 - 3:30
Is appearing in Excel as

But this is how it is in excel

M People - Moving On Up - Funky Divas cd 2 - 210

any ideas

Thanks...
 
B

Bob Phillips

It is showing the time in minutes, you need to divide by 86400 and format

TEXT(playtime/86400,"mm:ss")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top