Export CSV TIME


#1

Hello
I am Chilean and I use Google Translator

When I export the metadata in CSV (excel), the times do not export them well. I explain.
If an mp3 lasts 16 minutes 5 seconds, it exports it 16:05, correct;
but, if an mp3 lasts 49 minutes 5 seconds, it exports it as 49:05:00.
I have tried all Excel configurations in their time formats; but most advisable, is that Mp3tag, represents everything with values ​​00 hour: 00 minutes: 00 seconds to avoid problems.
Can someone help me please?


#2

Perhaps it is not best to export _LENGTH but the field %_length_seconds% and then format it in Excel