# Timestamp resolution of Easy Chart Save to XLS

**URL:** <https://forum.inductiveautomation.com/t/timestamp-resolution-of-easy-chart-save-to-xls/21645>\
**Category:** Ignition\
**Created:** [January 2, 2019, 4:55pm UTC](https://forum.inductiveautomation.com/t/timestamp-resolution-of-easy-chart-save-to-xls/21645 "2019-01-02T16:55:31Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![MikeAllgood](https://avatars.discourse-cdn.com/v4/letter/m/a183cd/32.png) [@MikeAllgood](https://forum.inductiveautomation.com/u/MikeAllgood)\
**Post date:** [January 2, 2019, 4:55pm UTC](https://forum.inductiveautomation.com/t/timestamp-resolution-of-easy-chart-save-to-xls/21645/1 "2019-01-02T16:55:31Z")

</div>

When I click the save button on an easy chart, the resulting XLX file has a timestamp (t\_stamp column) resolution to the minute. Is there a way to get a higher resolution on this timestamp value? Seconds or milliseconds?

Thanks,  
Mike

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [January 2, 2019, 5:49pm UTC](https://forum.inductiveautomation.com/t/timestamp-resolution-of-easy-chart-save-to-xls/21645/2 "2019-01-02T17:49:31Z")

</div>

It looks like the data should be in there down to millisecond resolution - if you open an easy chart export .xls file (_without_ opening it in Excel first!) in a text editor such as Notepad++ or Sublime Text, what does each cell value have? In my case, a simple test had a format like this:  
`<Cell ss:Index="1" ss:StyleID="s21"><Data ss:Type="DateTime">2019-01-02T09:29:00.000</Data></Cell>`  
Assuming the date format is the same in your file, it might just be a cell formatting change within Excel to display the resolution you’re looking for. If the data’s _not_ there in the .xls format, then something else is going on.

---

<div class="post-metadata">

**Author:** ![MikeAllgood](https://avatars.discourse-cdn.com/v4/letter/m/a183cd/32.png) [@MikeAllgood](https://forum.inductiveautomation.com/u/MikeAllgood)\
**Post date:** [January 2, 2019, 7:02pm UTC](https://forum.inductiveautomation.com/t/timestamp-resolution-of-easy-chart-save-to-xls/21645/3 "2019-01-02T19:02:20Z")

</div>

Thanks for the quick reply.

Opening the file in Notepad++ I do see msec data.  
It looks like the data is there in Excel too, unless it is opened and then saved before the data gets formatted to show the msec. Then It looks to overwrite the timestamps with the rounded second values.

Thanks,  
Mike