Export Downtime Table to Excel

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:


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.

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