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.
TIMEVALUE()
and display the float it is comprised of. So that I can highlight the inconsistencies.Submitted Time
corelates toSubmitted Time As Number
andSubmitted Text time
corelated toSubmitted Text Time As Number