Skip to main content
Solved

Duration Data Not Importing Correctly

  • May 23, 2024
  • 2 replies
  • 19 views
K
Forum|alt.badge.img+4

Hi,

I'm trying to import duration data from a CSV (e.g., "2:52:32" meaning 2 hours, 52 min, 32 sec). The Airtable  Duration field is set up correctly (I think?) with the h:mm:ss time format selected. I want to keep it as a duration field so I can calculate sums, avgs, etc.

When I import the data, the duration is not aligned correctly. For example, the original duration in the CSV is "23:51:52," but when it's imported, the duration is showing as "0:23."

What can I do to correct this? 

Thank you so much.

Best answer by TheTimeSavingCo

Sigh yeah, I couldn't get this to work either

I ended up using a workaround by importing that value into a text field instead.  After that imported, I copied the values from the text field into the duration field and that worked fine


2 replies

TheTimeSavingCo
Forum|alt.badge.img+31
  • TheTimeSavingCo
  • Brainy
  • 6457 replies
  • Answer
  • May 24, 2024

Sigh yeah, I couldn't get this to work either

I ended up using a workaround by importing that value into a text field instead.  After that imported, I copied the values from the text field into the duration field and that worked fine


Adam, Airtable Consultant - thetimesaving.company
K
Forum|alt.badge.img+4
  • Kate_Garcia
  • Author
  • New Participant
  • 1 reply
  • May 24, 2024

Sigh yeah, I couldn't get this to work either

I ended up using a workaround by importing that value into a text field instead.  After that imported, I copied the values from the text field into the duration field and that worked fine



Thanks, Adam. That worked. 


Terms & ConditionsAccessibility statement