+ Reply to Thread
Results 1 to 3 of 3

Calculating cumulative 'time spent' across multiple sheets.

  1. #1
    Registered User
    Join Date
    09-11-2014
    Location
    Carlisle, England
    MS-Off Ver
    2010
    Posts
    6

    Calculating cumulative 'time spent' across multiple sheets.

    While at work I currently have a Timesheet set up in excel to monitor how much time each day is spent on specific tasks (tickets).
    It is formatted as such:

    Ticket | Description | Time


    I create a new sheet for each day.

    What I would like is to have a 4th column that could display the total time spent on each ticket. So it would SUM each of the 'time' values that had the same ticket reference across all the sheets.
    Is something like this doable?

    Thanks

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,038

    Re: Calculating cumulative 'time spent' across multiple sheets.

    Google Excel 3D Reference or Excel 3D Lookup
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Calculating cumulative 'time spent' across multiple sheets.

    Why have a worksheet for each day? You have a million+ rows to work with. All you would have to do is enter under TIME the Date and Time. Then, calculations and charts can be easily made for any time period.

    If the data is in a TABLE then searching for specific items is quick and easy using the built in Table Filters. If you don't like to use the Table feature you can still use the Data Filter.

    Creating 1 worksheet per day will result in hundreds of worksheets which will over time be very awkward to work with.

    Something like this might work for you.
    Attached Files Attached Files
    Last edited by newdoverman; 09-11-2014 at 11:35 AM.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculating total time spent by half hour
    By sublime_01 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-12-2014, 06:25 PM
  2. Calculating time spent between seperate dates/times
    By JoshuaJared in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-17-2014, 12:19 PM
  3. Chart plotting time spent for multiple tasks and results
    By CocoaNut in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-14-2013, 07:07 AM
  4. Replies: 0
    Last Post: 08-08-2011, 05:11 AM
  5. [SOLVED] Cumulative Time Problem calculating more than 24 hours.
    By J in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-20-2005, 11:05 AM

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