Make converting values automatically

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

As you can see in the image above, the time stamp value is 00:50, but in the spreadsheet he entered this value: 0.0347222222222222

I’m putting the timestamp into the spreadsheet like this:
image

detail: this doesn’t always happen, there is no pattern

Hey Fabio,

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.

1 Like

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.

Good Morning @FABIO,

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.