date and time / timestamp bug when exporting to excel

0 Votes

date and time / timestamp bug when exporting to excel

I am trying to generate graphs of open rate and click throughs based on the timestamp when I export to excel. When I open in excel, the time imports as 10:59pm instead of 10:59 PM: the missing space after the last number makes the date/time read as text instead of a time, and there is no way to reformat with writing a short script to add the space to every line item. Can Constant Contact reformat how time is displayed on your end, or at least reformat when someone clicks export? I called in today, case# 22339859
2 Comments
Occasional Contributor

nevermind, this was answered in a previous post, thanks

Moderator
Status changed to: Closed - No Action

Glad you were able to find the answer!  Let us know if there's anything else you need assistance with.