Excel format/Download problem

  • AppQuality
    Asked on February 19, 2021 at 6:44 AM

    Hi everyone,

    when I download from submission an Excel File, I realize that there are some problems in the format "Hour:Minutes" .

    Indeed Excel isn't able to recognize the format although I assign the correct format.

    Some weeks ago there were no problem and I did all the formulas(average, median etc..) without any problem.

    Kind regards


    Jotform Thread 2910015 Screenshot
  • Richie JotForm Support
    Replied on February 19, 2021 at 8:51 AM

    To clarify, when you download your submission data as excel, it cannot detect the time field format as time?

    May I know if you're trying to use formulas in your excel calculation?

    Can you please share the calculations so that we can try to replicate the issue at our end?

    Looking forward for your response.