# How do you format the timestamp when importing a playlist?

**URL:** <https://forum.spinitron.com/t/how-do-you-format-the-timestamp-when-importing-a-playlist/347>\
**Category:** 🎼 Playlists\
**Created:** [March 9, 2021, 5:02pm UTC](https://forum.spinitron.com/t/how-do-you-format-the-timestamp-when-importing-a-playlist/347 "2021-03-09T17:02:34Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dean\_Mattson](https://forum.spinitron.com/user_avatar/forum.spinitron.com/dean_mattson/32/225_2.png) [@Dean\_Mattson](https://forum.spinitron.com/u/Dean_Mattson)\
**Post date:** [March 9, 2021, 5:02pm UTC](https://forum.spinitron.com/t/how-do-you-format-the-timestamp-when-importing-a-playlist/347/1 "2021-03-09T17:02:34Z")

</div>

For my last show - which I prerecord - I tried to import a playlist from a spreadsheet. It worked pretty well - it imported almost everything correctly like the song titles, artists, albums, durations, years, etc. However the one field that didn’t work was the one where I had the time where each song started. I then had to go in and manually adjust each song’s start time.

So what is the correct format for including this information? If I have a show that runs from 6 to 8 PM and I have a song that starts at 6:42 PM, do I enter 6:42, 18:42, 6:42 PM or 6:42PM?

---

<div class="post-metadata">

**Author:** ![Dean\_Mattson](https://forum.spinitron.com/user_avatar/forum.spinitron.com/dean_mattson/32/225_2.png) [@Dean\_Mattson](https://forum.spinitron.com/u/Dean_Mattson)\
**Post date:** [March 14, 2021, 4:02pm UTC](https://forum.spinitron.com/t/how-do-you-format-the-timestamp-when-importing-a-playlist/347/2 "2021-03-14T16:02:03Z")

</div>

After a little bit of experimenting, 6:42 PM will work in the example above. If you have an AM show, you can leave off the AM and it’ll add that automatically after you import your playlist. At least it did for me.