I have an automation that analyzes the text transcription of a call, analyzes whether the seller asked the questions in the playbook and then throws it into a json
that looks like a formatting issue within the sheet it self. Most likely its expecting a decimal value and not time value.
00:50 can be seen as 50 mins after midnight. In a day you have 24h times 60 mins is 1440 mins. And 50 divided by 1440 is 0.03472222… So it looks like the sheet is trying to convert the timestamp to a decimal number instead.
Good morning, how are you? First of all, thank you for your reply!
Could the problem be in the spreadsheet? It didn’t occur to me, because there is no pattern… it happens randomly…
The same thing happens with percentages, if I put 77% in the spreadsheet it shows 0.77.
I didn’t put any formula in the spreadsheet or anything like that.
Yes, the issue is with the format in the spreadsheet, not the data from the Automation.
When using Dates or Percentages, you need to configure the entire column format correctly.
I’ve attached an image to help guide you through the formatting process.