# Time Sheet with Time ONLY Fields

Topic Labels: Formulas
Solved
1237 1
cancel
Showing results for
Did you mean:  6 - Interface Innovator

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  10 - Mercury

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 minutes`MINUTE([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  10 - Mercury

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 minutes`MINUTE([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 