>Hello,
>
>I am using WMP 10 on XP Home SP2 with the media info exporter plug-in from the bonus pack.
>
>I am wanting to use this exporter to export a playlist and then print it. However, it exports the length of the songs in seconds rather than minutes and seconds. How can one fix this so that one can print the length of the songs?
There's an excel exporter in the bonus pack - is that what you mean ?
You'd have to do that in Excel ; Create a function using the fX button
in excel's top bar, and look up ways to convert seconds to minutes +
seconds, usually one column divided by 60 and another using MOD 60
(i.e the MOD function which takes say a value of 183 and divides by
60, returning the remainder of 3 seconds)
Then use CONCAT to join the two columns values into a 3rd "string"
column, along with min / sec or " ' or whatever you prefer.
HTH
Cheers - Neil
BBran - 11 Apr 2006 22:34 GMT
Yes, I meant the bonus pack. Thanks for the tip!
>Hello,
>
>I am using WMP 10 on XP Home SP2 with the media info exporter plug-in from the bonus pack.
>
>I am wanting to use this exporter to export a playlist and then print it. However, it exports the length of the songs in seconds rather than minutes and seconds. How can one fix this so that one can print the length of the songs?
There's an excel exporter in the bonus pack - is that what you mean ?
You'd have to do that in Excel ; Create a function using the fX button
in excel's top bar, and look up ways to convert seconds to minutes +
seconds, usually one column divided by 60 and another using MOD 60
(i.e the MOD function which takes say a value of 183 and divides by
60, returning the remainder of 3 seconds)
Then use CONCAT to join the two columns values into a 3rd "string"
column, along with min / sec or " ' or whatever you prefer.
HTH
Cheers - Neil