Title: Date/Time
Last modified: May 8, 2020

---

# Date/Time

 *  Resolved [Dave Pederson](https://wordpress.org/support/users/ironviking/)
 * (@ironviking)
 * [6 years ago](https://wordpress.org/support/topic/date-time-6/)
 * Tobias,
 * First, great job. This may do just what I need.
    I have one issue. I’m importing
   a xlsx, one column is defined as a time code format as h:mm:ss, when I import
   it is comes in as 1970-01-01 00:00:01.
 * Any suggestions?
 * Thanks

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Thread Starter [Dave Pederson](https://wordpress.org/support/users/ironviking/)
 * (@ironviking)
 * [6 years ago](https://wordpress.org/support/topic/date-time-6/#post-12804512)
 * I converted it to a CSV and it works fine. It’s an extra step in the process
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [6 years ago](https://wordpress.org/support/topic/date-time-6/#post-12804556)
 * Hi,
 * thanks for your post, and sorry for the trouble.
 * Yes, the Excel import is still experimental, as it still has trouble with different
   data formats, date and time in particular.
    Using the work around with the CSV
   file is the best choice here, for now.
 * Best wishes,
    Tobias

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Date/Time’ is closed to new replies.

 * ![](https://ps.w.org/tablepress/assets/icon.svg?rev=3192944)
 * [TablePress - Tables in WordPress made easy](https://wordpress.org/plugins/tablepress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/tablepress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/tablepress/)
 * [Active Topics](https://wordpress.org/support/plugin/tablepress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/tablepress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/tablepress/reviews/)

## Tags

 * [date-time format](https://wordpress.org/support/topic-tag/date-time-format/)

 * 2 replies
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [6 years ago](https://wordpress.org/support/topic/date-time-6/#post-12804556)
 * Status: resolved