When I submit a Google Form, and I fill in a time the number that is entered into the spreadsheet is not the same number the spreadsheet will use for that time.ie. If I enter 3:30 PM in a form and submit it. It enters the number 0.1458333333357590 into the google spreadsheet. If I type out 3:30 PM in the spreadsheet it is represented by: 0.1458333333333330. Here is an example Form and Spreadsheet you can see this on. Go to the form, enter a time in the time picker, and enter your time as a string. You can then go to the spreadsheet and see that the submitted time does not equal the actual time the spreadsheet uses.Link to FormLink to SpreadsheetWhy does this happen, and how can I fix it? This seems like a docs bug to me...Related To: FILTER() Is not returning consistent resultsNew Question with entirely different premises.
Google Forms submits times that are not numerically consistent with those in a spreadsheet
google spreadsheets;google forms