How to get Start Time and End Time automatically in the Data Sheet

User Support Data Management
1

Hi team,
In the data sheet it is appeared start and end date only. I have a requirement to get the start and end times as well. Please be kind enough to support me in assisting how to get the start time and end times of respondings.
Thank you.

2

Hi @raveendra,

If you include start-time and end-time in metadata, you will be able to see the times aswell. You can find more information in this help article:

https://support.kobotoolbox.org/form_meta.html

1 Like
3

Hii… Thank you for responding…
I have included those metadata as the instructions. But only the date will be displayed as in the attached image.

Thank you…

2022-12-26 at 16-26-15

4

Can you please share the xls version of the form so we can check? because as far I see from the picture, it could be an issue related to excel

1 Like
5

Hi @raveendra you need to change the format of the cell to see it.

1 Like
6

Hii… Please find the XLS form. And please advise me.

01. Excell Programmed File.xlsx (48.6 KB)

7

That means, please.

8

@raveendra, there is no problem in your XLSForm. When you download your data, you can format the cell to your needs. There is a microsoft help article about how you can format your date and time cells: Format numbers as dates or times - Microsoft Support.

1 Like
9

As Hakan mentioned, your form looks normal but your excel formats the start and end columns as short date, you need to use long date format

2 Likes
10

Hii… Thank you for your guidance. I made the formate in excel and time will be appeared.
Thank you again.

I have another concern, when the respondances change their device time, will it affect to the data sheet?

11

Yes. It is working. Thanks for the guidance.

12

You can also change the start and end metadata (as well as submission_time) to text with the Excel function transfer text …
This will be an advantage if you use other tools, like SPSS, with different date-time base.

Both are local times, so at least end will chsnge with the configuration of the device.

Be aware that

  • start is the first open date/time
  • end is the last save date/time.

Both might differ from the real date/time of an interview.

But submission_time is the Kobo Server date/time

1 Like
14

Thank you for the support…

1 Like