+ Reply to Thread
Results 1 to 2 of 2

Running Total excel stat sheet

  1. #1
    Registered User
    Join Date
    03-27-2010
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    16

    Running Total excel stat sheet

    Hello i am wanting to know how i would go about making a running total stat graph.
    Basically what i need is this:
    I work a certain amount hour, in that period i need to get say 7 stats per hour.
    So if i start at 3:00pm and work til 4:00pm i need to be on 7 stats.
    So if i am on 7 at this time, the graph would show:


    This is what i mean

    http://img179.imageshack.us/img179/5829/statsos.jpg

    Basically it calculates what stats you should have based off your start time/end time,
    Every time you click on a new order it record the time.



    How would this work?
    Thanks

  2. #2
    Registered User
    Join Date
    03-27-2010
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    16

    Re: Running Total excel stat sheet

    Basically i want a REPT function that does this,
    Where once you reach a certain amount of stats it changes color and goes up as shown above,

+ 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