Skip to main content

Hi people!

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!

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.


Hey ​@Mai_Nguyen,

For further cont​@DisraeliGears01 answer above, you can check this Airtable support article for Duration fields. -screenshot of relevant part below.

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.

 

  
Mike, Consultant @ Automatic Nation


Thanks for your responses guys! I added a formula field on Airtable to convert this number to Google Sheet friendly format. This works perfectly fine. 


Reply