Duration Data Not Importing Correctly

[Kate_Garcia]

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.

[TheTimeSavingCo · Accepted solution]

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

[Kate_Garcia]

Thanks, Adam. That worked.