+ Reply to Thread
Results 1 to 6 of 6

Finding Weekly Totals

Hybrid View

  1. #1
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2505
    Posts
    27,222

    Re: Finding Weekly Totals

    Why are you not counting all the minutes for every day? It looks like you are counting only the minutes in the last row for each day.

    This could be done with macros, might also be possible with formulas. Do you have a preference?

    This would also be a lot easier if instead of the names of the days you had the actual dates.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  2. #2
    Registered User
    Join Date
    10-12-2003
    Posts
    34

    Re: Finding Weekly Totals

    Thanks 6String

    Yes I do actually have the dates of each event. Also I can keep a cumulative or running total of minutes for the events. The part that is puzzling to me is creating a "flag" to start and stop the count. To make this much easier, I have modified the sample file and am uploading it again with additional columns.

    Note that each row or event is entered one at a time via a macro. You will note that the second Weekly Total shows up on the last row for a Monday. This is due to the fact that NO events occurred or were entered on Tue of that week. This can only be known when the FOLLOWING event is entered and the Day of that event is beyond Tuesday. Then the weekly total needs to be inserted on the prior row (Event 18) which is the last event of the week.
    I would like to include this as part of the code which "Posts" the data to the table - one record at a time. Hence as each record is entered, the entry date must be checked to see if it is at least a "Wednesday". But if there is no event on Wed, then if would be Thursday or later. Each time there is a Weekly Time posted the "counter" needs to reset back to zero.

    Thanks for your help.
    Attached Files Attached Files
    Last edited by gocush; 11-24-2012 at 12:25 AM.
    Paul

+ 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