This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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!
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
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
