How can I subtract the hours worked from total allotted hours?

I am trying to track the total hours worked for an external vendor. We are paying for their service for a certain number of hours and each week I want to subtract the hours worked for that week from the allotted hours. I want a cell that gives me the total and subtracts out hours worked. I cannot, for the life of me, figure out how to do this. Can someone help me figure out a formula for this?

As an example:

600 (Hours we have to work with)

50 (worked week 1)

40 (worked week 2)

Total hours available: 510

Find more posts tagged with

Formulas

Accepted answers

All comments

Stefan

Hi @BethWork,

as this seems rather basic (see below) I assume there must be a hidden blocker, like the way you get the input for hours worked...

Anyway, do you have something like this in mind?

Hope this helps!

Stefan

BethWork

Hi @Stefan,

I think this will work. I don't know where to use the =SUM(CHILDREN()) formula though.

Here's what I tried:

I entered this formula in the Hours Available column

=[Allotted Hours]@row-[Hours Worked]@row

Stefan

Hi @BethWork,

yes, this will work if you only have one client per sheet.

In my example I indented the rows below client "Hans" so that the =SUM(CHILDREN()) formula actually finds children. Indenting marks rows indented to "children" of the next row above that is less indented.

Hope this helps!

Stefan

BethWork

@Stefan

Ah, ok! I do only have one client so that works perfectly! Thank you for your help.

Stefan

@BethWork,

then you have your solution ready :-)

Pleasure

Stefan

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.