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:
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.
Why does this happen, and how can I fix it? This seems like a docs bug to me...
Related To: FILTER() Is not returning consistent results
New Question with entirely different premises.