Hey all,
so weirdly enough, when I setup the formula for a total time calculated it shows this:
120 minutes, correct?
However the resultant display shows this:
Just curious, why is it showing up as 0:02 instead of 120, even though in the sample it shows it’ll be 2?
You have the formula formatted to duration h:mm, which abstracts it down to the nearest hour. If you keep it as a duration and turn it to h
ss it’ll show as 2:00 instead (for two hours). If you want the actual number of minutes (120) change the formatting to number.
This all has to do with how duration fields are calculated and formatted intersecting with how Airtable calculates time (by the second)
That’s because answer is 120, datediff outputs just number, without units.
On the other hand, Duration gets this number as ‘seconds’ and you see 2 minutes in format ‘h:mm’.
You can see that if you add seconds.
So, if Duration wants ‘seconds’ give it ‘seconds’ (instead on ‘minutes’)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.