Help

Re: Hours remaining in the day

801 0
cancel
Showing results for 
Search instead for 
Did you mean: 
E007
6 - Interface Innovator
6 - Interface Innovator

How would I subtract a duration from the total number of hours in the day? For example, if I have a task that takes 6 hours, I’d like to set up a field that shows how many hours are left in the work day.

I’ve tried a few things but keep getting errors.

Thanks!

4 Replies 4
Mike_McLaughlin
8 - Airtable Astronomer
8 - Airtable Astronomer

can you post your formula that gives you the error?

Hi @E007 - if your hours in the day and hours worked are both “duration” fields, you can just take them away to get the remaining time:

Screenshot 2019-04-02 at 11.37.33.png

The formula for “Remaining Time” in my example is:

{Hours in Day} - {Time Worked (Duration)}

You also have to set the format of the formula field to duration too:

45

JB

A solution so simple and elegant yet I didn’t even see it. Thanks, Jonathan!

Thanks for being willing to help, Mike!