I am trying to establish an automation which appends a row to Google Sheet when the certain cell in Airtable is filled.
Everything is ok except that duration data from a formula cell is not synced as h:mm as in Airtable but instead I get some strange number such as 3427.
Is there any way I can correct this?
Thanks so much!
Page 1 / 1
Hi there. Following up on this question, were you able to solve this issue? I’m having the same problem.
Duration is stored as seconds on the backend, so unless you change the formatting of a formula it’ll show the duration in terms of total seconds (so 1 hour or 1:00 in a duration field turns into 3600, which is the number of seconds in an hour).
Are you having the exact same problem as OP with regard to Google Sheets? I assume it’s exporting the raw numeric value, which you could either clean up by adding /60 to your formula (which will result in a much more comprehendible total minutes) or look at the token in the automation and see if you can change it to better match what you need.
Depending on how and on what software your automation is setup whether you’ll want to process the data on the automation itself, or whether you will want to handle it on google sheets.