Help

Duration Data Not Importing Correctly

Topic Labels: Importing & Exporting
Solved
Jump to Solution
164 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Kate_Garcia
4 - Data Explorer
4 - Data Explorer

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.

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

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


See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

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.