Results 1 to 3 of 3

Distribute Value by Hour

Threaded View

dreicer_Jarr Distribute Value by Hour 02-20-2011, 06:01 PM
dreicer_Jarr Re: Distribute Value by Hour 02-20-2011, 07:13 PM
daddylonglegs Re: Distribute Value by Hour 02-20-2011, 09:00 PM
  1. #1
    Forum Contributor
    Join Date
    04-02-2008
    Location
    Jacksonville Beach, Florida
    MS-Off Ver
    Microsoft Excel 2003 and 2010
    Posts
    264

    Distribute Value by Hour

    How can one distribute a cell value (A2) over the course of a number of hours (B2) using the inputs in column D of the attached? I provided an expected result but keep in mind that the cells in yellow need to be adjustable and I used 4 hrs in the example because the math is very simple to calculate. My issue is creating a formula that can work with the adjustable input cells and distribute the value in A2 by any given number of hours entered in B2 between 0 and 6.9.

    I have been trying for hours on this even though it may seem simple to some...I would REALLY appreciate any help...and let me know if I can make this explanation any clearer.

    Thanks,

    D
    Attached Files Attached Files
    Last edited by dreicer_Jarr; 02-20-2011 at 09:06 PM.
    ______________________________________
    "Vision without Execution is a Hallucination"
    Edison

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