What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.

  • Profile Image

    How to separate Date and Time in Excel report?

    Asked by markrichards on May 18, 2015 at 03:37 PM

    My jotform download into excel won't allow excel to recognise the dual entry in a single cell of the combined date and time. Solution?

  • Profile Image
    JotForm Support

    Answered by BJoanna on May 18, 2015 at 04:41 PM

    From the screenshot you have provided and after seeing your form, from what I can see Excel report is good and formatted like it need to be. For fields inside of your form Call to Metro date and time, Dispatch Time, Hospital Arrival TIme you are using DateTime picker and all of those fields:

    Date, Year, Month, Hours and Minutes are representing one field and they will be shown inside one column in Excel report.

    Do you want to achieve something else, maybe to separate date and time, that time is in other column? You can achieve that by creating two fields, one field for Date and one field for Time inside of your Form Builder.

    If you create your Date and Time fields separated then you will have them separated as well inside of Excel report.

    Hope this will help. Let us know if you need further assistance.  

  • Profile Image

    Answered by markrichards on May 19, 2015 at 02:46 PM

    Hello Joanna

    Many thanks for your reply. Do appreciate it. 

    I think I have run into an excel gremlin as the functionality of creating a time difference (duration) within google sheets works smoothly. I suspect in copying data over I have had the cells formatted as text.


  • Profile Image
    JotForm Support

    Answered by BJoanna on May 19, 2015 at 03:04 PM

    You're welcome. I am not sure if you have any issues.

    Do let us know in case that you need further assistance.