+ Reply to Thread
Results 1 to 4 of 4

Combine a sheet of timesheet entried with a sheet of hours purchased by client

  1. #1
    Registered User
    Join Date
    11-09-2013
    Location
    england
    MS-Off Ver
    Excel 2013
    Posts
    2

    Combine a sheet of timesheet entried with a sheet of hours purchased by client

    Hi -

    I have a sheet of multiple time sheet entries from work done on all our client projects, and a sheet of data which shows how many hours per month each client buys. I am able to pivot the data to show how much time each client uses per month, and another pivot with how many hours they pay for, but for the life of me i cant create a sheet which shows hours spent per month, and underneath hours bought per month, with the varience!

    This is my first post so hopefully i am complying with the rules.

    Thanks in advance!

  2. #2
    Forum Contributor amit.wilson's Avatar
    Join Date
    07-09-2013
    Location
    Gotham
    MS-Off Ver
    Excel for Mac 2011
    Posts
    283

    Re: Combine a sheet of timesheet entried with a sheet of hours purchased by client

    Hi - can you post a sample/example sheet?

    Cheers
    <-- If you're happy & you know it...click the star.:-)

  3. #3
    Registered User
    Join Date
    11-09-2013
    Location
    england
    MS-Off Ver
    Excel 2013
    Posts
    2

    Re: Combine a sheet of timesheet entried with a sheet of hours purchased by client

    Hi - the sample file is 1.4mb but it wont let me upload it!

  4. #4
    Forum Contributor amit.wilson's Avatar
    Join Date
    07-09-2013
    Location
    Gotham
    MS-Off Ver
    Excel for Mac 2011
    Posts
    283

    Re: Combine a sheet of timesheet entried with a sheet of hours purchased by client

    Do you want to try create a small sample file... with 5-10 entries? I need an example to work off.

    Cheers

+ 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. Replies: 2
    Last Post: 06-11-2014, 11:14 AM
  2. Replies: 0
    Last Post: 06-03-2013, 07:03 PM
  3. One spreadsheet but adding hours on a client by client basis..
    By arthurArthur in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-01-2013, 01:58 AM
  4. Replies: 2
    Last Post: 06-25-2012, 09:30 AM
  5. Replies: 8
    Last Post: 02-21-2012, 01:38 PM

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