I would like to convert the time to note. However, in my ODK collect, it only shows the Date instead of Time.
Hope someone can help me on this. Thank you!
I would like to convert the time to note. However, in my ODK collect, it only shows the Date instead of Time.
Hope someone can help me on this. Thank you!
Hi @Makino
You need to use format-date-time function. Here is a sample form which should solve your problem:
TimeFormatTest.xlsx (4.8 KB)