
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 01, 2019 06:02 PM
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!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 01, 2019 06:30 PM
can you post your formula that gives you the error?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 02, 2019 03:41 AM
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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 02, 2019 06:33 AM
A solution so simple and elegant yet I didn’t even see it. Thanks, Jonathan!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 02, 2019 06:34 AM
Thanks for being willing to help, Mike!
