+10Hi
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
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.
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
