# Excel won't show full timestamp from Power Table

**URL:** <https://forum.inductiveautomation.com/t/excel-wont-show-full-timestamp-from-power-table/111785>\
**Category:** Ignition\
**Created:** [October 29, 2025, 12:59pm UTC](https://forum.inductiveautomation.com/t/excel-wont-show-full-timestamp-from-power-table/111785 "2025-10-29T12:59:06Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![jparsons1](https://avatars.discourse-cdn.com/v4/letter/j/f14d63/32.png) [@jparsons1](https://forum.inductiveautomation.com/u/jparsons1)\
**Post date:** [October 29, 2025, 12:59pm UTC](https://forum.inductiveautomation.com/t/excel-wont-show-full-timestamp-from-power-table/111785/1 "2025-10-29T12:59:06Z")

</div>

I have a power table with a timestamp in mm dd, yyyy hh:mm:ss AM/PM format. I created an excel file with the System.Dataset.ExportExcel function with that dataset except that the timestamp just comes through as mm/dd/yy. The hour/minute/second format got lost in the process. Is there a way to ensure that this moves over to excel?

---

<div class="post-metadata">

**Author:** ![jparsons1](https://avatars.discourse-cdn.com/v4/letter/j/f14d63/32.png) [@jparsons1](https://forum.inductiveautomation.com/u/jparsons1)\
**Post date:** [October 29, 2025, 1:02pm UTC](https://forum.inductiveautomation.com/t/excel-wont-show-full-timestamp-from-power-table/111785/2 "2025-10-29T13:02:14Z")

</div>

I just found that the full timestamp wasn’t lost, excel just sets it to “date” format. When you change the format of the column the time comes back. Is there a way to automatically set this in the ignition script?

---

<div class="post-metadata">

**Author:** ![MMaynard](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mmaynard/32/3366_2.png) [@MMaynard](https://forum.inductiveautomation.com/u/MMaynard)\
**Post date:** [October 29, 2025, 2:25pm UTC](https://forum.inductiveautomation.com/t/excel-wont-show-full-timestamp-from-power-table/111785/3 "2025-10-29T14:25:21Z")

</div>

There are a few examples in the forums here to do this.

Just search excel date and it will bring up some relevant topics.

One that can get you started is

[Dataset export to Excel datetime conversion issue - Ignition - Inductive Automation Forum](https://forum.inductiveautomation.com/t/dataset-export-to-excel-datetime-conversion-issue/33617/5)

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [October 29, 2025, 2:46pm UTC](https://forum.inductiveautomation.com/t/excel-wont-show-full-timestamp-from-power-table/111785/4 "2025-10-29T14:46:26Z")

</div>

Consider using the Apache POI libraries that come with Ignition to do a custom export. Then you can actually apply a desired datetime format to cells containing java dates. (The linked topic uses string formatting, which is lossy.)