just in time too! I began searching for a solution to this problem yesterday!
I do have another number format problem with dates though. A few columns in my app work out the difference between two date/times and spits out the result as a number (i.e, 11:50 is formatted as 43897.4930555556) in my sheet.
The value is input from my app into the the sheet using a form component (which requires a date//time selector, when i ONLY need a time selector … more on that here). The sheet also has an array formula to perform the difference calc, which is also formatted in as a number. any suggestions on how to have the results in my sheet automatically formatted to a time format?