Apr 30, 2020
Hi everyone. I am trying to make a formula that will take two time-only fiends (formatted as) HH:00aa and give me the total time in hours rounded to the nearest quarter. (e.g. 2.75, 1.25).
This has been very difficult since all of the help I could find seemed to be geared toward Date/Time fields. Thank you ahead of time for any help you can give me!
Go to Solution.
May 01, 2020
I’m not sure this is right, but this is where I’d start solving this problem.
Airtable doesn’t have time only fields. I don’t know why. But it does have a lot of cool Date/Time formulas that will help you here.
So in your formula, I’d suggest you do the following.
Extract the hour HOUR([datetime])
Extract the minutesMINUTE([datetime])
Use the minutes’ value to divide by 50 and then use ROUND(value, precision) to round to the value you’re looking for
Hope that helps!
Here’s the reference sheet in case you need it
See Solution in Thread