title: Exporting to Excel - What to do with timestamps?
body: <p>I've got Time objects that I'm writing to an Excel file.  I'm using the axlsx library.  The class that converts dates to the cell data is <a href="https://github.com/randym/axlsx/blob/master/lib/axlsx/workbook/worksheet/date_time_converter.rb" rel="nofollow"><code>DateTimeConverter</code></a>, which turns it into a float timestamp.</p>
  
  <p>The times are displayed as <code>mm/DD/YYYY HH:MM:SS</code> as expected, but the values are in GMT time.</p>
  
  <p>Is there a way to make Excel format the times for a particular time zone, or the reader's local timezone?  My current solution is to export the formatted time as a string, and I am dissatisfied with this.</p>
  
  <p>Is there a way to do this without adding a VBA macro?  (Please note that I'm not trying to convert the local time to GMT with a VBA macro as per the linked "duplicate" question, but rather display the GMT time to a local time - preferably without a VBA macro, if possible.)</p>