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.
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.
Best Answer
There is a fractional time difference (milliseconds) between the time entered when you enter into the form vs directly into the sheet. Possibly this is a bug.
I think you can fix it by rounding the values: check for equality with a formula like
round(time1, 6) = round (time2,6)