1. What is the problem? Be very detailed.
I have developed a mobile application using the xls form in excel sheet. The data was coming swiftly through google drive because I have used the google sheet to collect the field data in real time. But, one of my colleague committed a mistake and copy pasted some of the rows to the bottom of the google sheet. because of this the first two columns in the google sheet, that is "data-starttime" and "data-endtime" has changed. It not showing the time, instead numbers like "44228.5409722222" is coming.
2. What app or server are you using and on what device and operating system? Include version numbers.
I have developed the application using the excel sheet and uploaded the sheet to ODK upload. finally I have connected it to the google sheet using the google drive.
3. What you have you tried to fix the problem?
I have tried deleted the pasted rows from the sheet that my colleague had done.
4. What steps can we take to reproduce the problem?
Kindly suggest the solution for this.
5. Anything else we should know or have? If you have a test form or screenshots or logs, attach below.