# Export Downtime Table to Excel

**URL:** <https://forum.inductiveautomation.com/t/export-downtime-table-to-excel/9899>\
**Category:** 3rd Party Modules\
**Created:** [April 9, 2015, 9:14pm UTC](https://forum.inductiveautomation.com/t/export-downtime-table-to-excel/9899 "2015-04-09T21:14:21Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sthayer](https://avatars.discourse-cdn.com/v4/letter/s/db5fbb/32.png) [@sthayer](https://forum.inductiveautomation.com/u/sthayer)\
**Post date:** [April 9, 2015, 9:14pm UTC](https://forum.inductiveautomation.com/t/export-downtime-table-to-excel/9899/1 "2015-04-09T21:14:21Z")

</div>

Hey everyone,

As the title implies, I’m exporting a downtime table to excel so we can see the most common downtime code, the longest code, when downtime happened, etc.

My only problem is that the begintime and endtime columns of the downtime table are of type calendar and look like the added screenshot below:

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/9/9530d863ec31b5e9958e6c52a532ca71bd9515e8.JPG)  

The export is useless if we can’t tell when these downtime codes happened. Is there any way to just get the timestamp that shows up in the downtime table? Thanks.

---

<div class="post-metadata">

**Author:** ![glogue](https://avatars.discourse-cdn.com/v4/letter/g/9fc348/32.png) [@glogue](https://forum.inductiveautomation.com/u/glogue)\
**Post date:** [April 13, 2015, 4:07pm UTC](https://forum.inductiveautomation.com/t/export-downtime-table-to-excel/9899/2 "2015-04-13T16:07:00Z")

</div>

You should be able to create a VBA script in Excel to convert this to a timestamp.