Time format Question


#1

Hi
I have a batch of data with a field that measures time spent in a system, the data varies as the two examples below

00:12
Which I’m reading as minutes:Seconds
8.02:40
Which i’m reading as Hours:Minutes:Seconds

Ideally I’d like the response to be a simple minutes value. is this possible in Airtable please?

Regards

Rob


#2

Kind of an answer:

Airtable now supports a duration field type, supporting a number of formats — or, rather, precisions: h:mm, h:mm:ss, h:mm:ss.s, h:mm:ss.ss, h:mm:ss.sss. (Unfortunately, a value entered as h.mm:ss is interpreted as ss.s, so you’ll need to import your values as a string and then convert them by replacing decimal points with colons.)

Internally, durations appear to be stored in seconds, so to arrive at a value in minutes, all you need do is configure a formula field with the formula {Duration}/60.