I'm wanting to add the length (time) of a track for export using csv. Length is nothing more than the time it would take a track to play. I'm not a programmer but I do know it can be done but I have no idea how to do it. Any help would be greatly appreciated

[image] xpac5896a: Perhaps I should go over to the Office Forum and maybe somebody over there can point me in the right direction. Yep, because your questions are no more Mp3tag related. Maybe this one can help: Add or subtract time - Microsoft Support Excel can calculate how ma…

Did you have a look at the help for the export function? There you find, among other property variables %_length% Length (formatted)

I've tried that and I get nothing. I've also tried %_length_seconds% and I get a number but you have to divide by 60 to get something close to time but doesn't represent the correct time (length of the song). Needless to say, my LENGTH is represented minutes, seconds i.e 03:34. I know there's a way …

Are you sure @xpac5896a ? Is this: [image] Placeholders export data Support %_length_seconds% will give you 234 seconds. %_length% will give you 03:54 (03 minutes and 54 seconds) not true anymore?

I use this setup in my column browser, works fine for me. You should be able to use the same field for an export. [image]

[image] xpac5896a: I've tried that and I get nothing. That is astounding. Could you show us the script snippet where you use it? Perhaps as a screendump?

Is the %_length% value missing for ALL of your files? Have you tried to validate the files in question to make sure there isn’t a header issue? It seems very strange that this value is missing but %_length_seconds% is populated. You mentioned that you need to divide this by 60, but that is correct f…

$filename(csv,utf-16)Title;Year;Artist;Album;Track;Length $loop(%_filename_ext%)%title%;%year%;%artist%;%album%;%track%;%_length% $loopend()build on %_date% with %_app% - the universal Tag editor - Mp3tag - the universal Tag Editor (ID3v2, MP4, OGG, FLAC, ...) This is what I’m using to export usi…

I would like to correct myself in regards to the string for time. The format %_length% does give you length, however, IT'S IN HOURS, not minutes and seconds. I did an AutoSum of 1137 songs just to see what I would get. The last cell was formatted in dd:hh:mm:ss the total was 14:19:14:00, that's 14 …

I exported a csv file with a few tracks, adding %_length% as the last field. All came out in the correct format. I had one track longer than 60 minutes, it came out as expected in the format 01:07:04 (1 hour, 7 minutes, 4 seconds) as expected. The rest were regular songs and came out in mm:ss only. …

[image] xpac5896a: This comes in handy if you want to calculate how long it would take to play all songs in your collection or you just might want to do just some of them. The export in MP3Tag knows global variables for this purpose which work for each loop. Have a look at the help in sectio…

Adding Length (time) to CSV

Support

LyricsLover December 29, 2021, 3:54pm 4

Are you sure @xpac5896a?

Is this:

not true anymore?