# Cannot Get Time to Display correctly on CSV file

**URL:** <https://community.mp3tag.de/t/cannot-get-time-to-display-correctly-on-csv-file/61378>\
**Category:** Support\
**Created:** [June 26, 2023, 4:18am UTC](https://community.mp3tag.de/t/cannot-get-time-to-display-correctly-on-csv-file/61378 "2023-06-26T04:18:49Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![voxquintinious](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/v/aca169/32.png) [@voxquintinious](https://community.mp3tag.de/u/voxquintinious)\
**Post date:** [June 26, 2023, 4:18am UTC](https://community.mp3tag.de/t/cannot-get-time-to-display-correctly-on-csv-file/61378/1 "2023-06-26T04:18:49Z")

</div>

I exported some songs and the length of the track displayed is a 3 or 4-digit number, I cannot format it in Excel to read in the 00:00 time format. Any suggestions on what I am doing wrong?

---

<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:** [June 26, 2023, 5:36am UTC](https://community.mp3tag.de/t/cannot-get-time-to-display-correctly-on-csv-file/61378/2 "2023-06-26T05:36:52Z")

</div>

Unfortunately, you do not show us the export script or what you do in Excel.  
So here is a thread in which there is an expression that adds further zeros to the output of a time variable:

> [@Change %\_length% to HH:mm:sec using 64bit MP3tag](https://community.mp3tag.de/t/change-length-to-hhsec-using-64bit-mp3tag/61371/):
>
> I know orienkino helped me in fixing this but apparently, I reverted to the 64bit Mp3Tag version and his resolution doesn't work in the 64bit version. When you download and install a new version of MP3tag, 32 or 64 bit, it does change your export string in MP3tag . I copied his resolution into the CSV string and when expressed in the CSV file, all you get is the expression no result. I wonder if anybody has resolved this problem for Excel? Below is a copy of the string I used to try to get the H…

---

<div class="post-metadata">

**Author:** ![system](https://community.mp3tag.de/uploads/default/original/2X/c/ce7035d426cb755a7916793326d23b465222a407.png) [@system](https://community.mp3tag.de/u/system)\
**Post date:** [July 26, 2023, 5:37am UTC](https://community.mp3tag.de/t/cannot-get-time-to-display-correctly-on-csv-file/61378/3 "2023-07-26T05:37:10Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.