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:

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:

JB
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:

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:

JB
A solution so simple and elegant yet I didn’t even see it. Thanks, Jonathan!
can you post your formula that gives you the error?
Thanks for being willing to help, Mike!