# Exporting Data from Trends graph to excel

**URL:** <https://forum.inductiveautomation.com/t/exporting-data-from-trends-graph-to-excel/2953>\
**Category:** Ignition\
**Created:** [May 18, 2011, 9:46am UTC](https://forum.inductiveautomation.com/t/exporting-data-from-trends-graph-to-excel/2953 "2011-05-18T09:46:06Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![peadair](https://avatars.discourse-cdn.com/v4/letter/p/da6949/32.png) [@peadair](https://forum.inductiveautomation.com/u/peadair)\
**Post date:** [May 18, 2011, 9:46am UTC](https://forum.inductiveautomation.com/t/exporting-data-from-trends-graph-to-excel/2953/1 "2011-05-18T09:46:06Z")

</div>

Hi i was just wondering if it is possible when exporting Data from Trends graph to excel to have consistent and rounded times for the values. What i mean by this is if you want to look at the trend for the last week in excel format it will have timestamp for every 10 minutes or an hour, not just random times.

---

<div class="post-metadata">

**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\
**Post date:** [May 30, 2011, 4:13am UTC](https://forum.inductiveautomation.com/t/exporting-data-from-trends-graph-to-excel/2953/2 "2011-05-30T04:13:10Z")

</div>

Just to make sure I understand what you mean: if you have things logging every five minutes, you want the exported data to look something like this:

1:00:00  
1:05:00  
1:10:00  
1:15:00

as opposed to something like this:

1:01:27  
1:05:27  
1:10:27

Is this what you were getting at?

---

<div class="post-metadata">

**Author:** ![peadair](https://avatars.discourse-cdn.com/v4/letter/p/da6949/32.png) [@peadair](https://forum.inductiveautomation.com/u/peadair)\
**Post date:** [June 3, 2011, 3:43pm UTC](https://forum.inductiveautomation.com/t/exporting-data-from-trends-graph-to-excel/2953/3 "2011-06-03T15:43:47Z")

</div>

Hi Carl,

No what i actually meant is that i would be getting times like

1:22  
1:24  
1:27  
1:31  
1:33

the seconds would not have bothered me.

I have resolved this issue it was down to the tag history resolution.

Thanks for the reply though.