# Export CSV TIME

**URL:** https://community.mp3tag.de/t/export-csv-time/42961
**Category:** General Discussion
**Created:** [September 15, 2018, 8:50am UTC](https://community.mp3tag.de/t/export-csv-time/42961 "2018-09-15T08:50:27Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![cesarhr](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/c/ac91a4/32.png) [@cesarhr](https://community.mp3tag.de/u/cesarhr)
#### Post date: [September 15, 2018, 8:50am UTC](https://community.mp3tag.de/t/export-csv-time/42961/1 "2018-09-15T08:50:27Z")

</div>

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?**

---

<div class="post-metadata">

### Author: ![ohrenkino](https://community.mp3tag.de/user_avatar/community.mp3tag.de/ohrenkino/32/4843_2.png) [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)
#### Post date: [September 15, 2018, 9:35am UTC](https://community.mp3tag.de/t/export-csv-time/42961/2 "2018-09-15T09:35:25Z")

</div>

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