On the _submission_time column in the xls form, it only shows date instead of date and time. Kindly assist on how to display the date and time in the _submission_time

[Osman_yotta]

[hakan_cetinkaya]

Hi @Osman_yotta and welcome to the community!

It actually stores the time You need to change the format of the cells.

More information about how to do that can be found in:

Format a date the way you want

[Osman_yotta]

thanks very much hakan.
Issue Resolved!

[wroos]

May we ask you, not to post twice in the forum for the same issue, please.
https://community.kobotoolbox.org/t/what-is-submission-time-that-is-seen-in-the-xls-dataset/5269/9