How to export timestamp on Excel?

  • Bailin_Goh
    Asked on November 29, 2022 at 5:15 AM

    Hi, I cant export the timestamp of my registrants. on the excel, only date stamp.

  • Mary JotForm Support
    Replied on November 29, 2022 at 5:35 AM

    Hi Bailin,

    Thanks for reaching out to Jotform Support. If you would like to export your submissions with the timestamp, you will need to change your date format on your submission tables:

    1669718088 6385e048ba0bd 6385e048ba080 Screenshot 10

    Once the submission is downloaded as excel, the date format together with the timestamp is carried over:

    1669718107 6385e05b7788d 6385e05b7784d Screenshot 21

    Let us know if there’s anything else we can help you with.