+ Reply to Thread
Results 1 to 2 of 2

Formula that subtracts from multiple totals based on date first entered

  1. #1
    Registered User
    Join Date
    12-19-2012
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2010
    Posts
    1

    Formula that subtracts from multiple totals based on date first entered

    I have a sheet that that tracts makeup hours I am required to work. As part of the sheet, I have a list of all of the holidays and time off. After each date, I have a limited time to make up the hours and I am required to document what each over time hour applies to. My sheet tracks weekly totals and total hours made up and total make up hours remaining. However, I need a formula that will allow automatically deduct hours from the holidays once those hours have been made up. For instance, I have a week to make up hours missed for Christmas Eve and Christmas Day and then another week for New Years Day. My total states I need to make up 24 hours. As the total of made up hours increases, I want it to first subtract the first 8 hours from Christmas Eve, the second 8 from Christmas day, and so on. What type formula would accomplish this?
    Attached Files Attached Files

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Formula that subtracts from multiple totals based on date first entered

    Hi jcroft11,

    Welcome to the forum.

    Where in the workbook you are referring to ?


    Regards,
    DILIPandey
    <click on below * if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1