Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Time Sheet with Time ONLY Fields

Topic Labels: Formulas
Solved
Jump to Solution
859 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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!

1 Solution

Accepted Solutions

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

1 Reply 1

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