Results 1 to 2 of 2

Thread: Importing Spreadsheets

  1. #1
    Join Date
    Jul 2005

    Thumbs up

    (I am not sure where to ask this question. I am thinking the Access forum would be better than Excel, but could be done in both.)

    I am working with 5 other people for an Architect, and I have designed separate bi-weekly time sheets in Excel. The spreadsheets are set up to calculate the time spent on each project a person does, vacation and holiday time, and then give a total at the bottom.

    Here's my questions: Is there anyway that Access or Excel can take a person's time and the client each person works on, and put it in a single spreadsheet to show how many hours each client has? For instance, 2 other co-workers are doing work on the same project I am, and the architect wants to know how much total time was spent for this client.

    What he really wants to see is column A list the job number; Column B list the client; Columns C - H be for the employees, and Column I be for the total times. Of course, down at the bottom of Columns C - H would be totals for each employee.

    Any ideas how this can be accomplished and which program (Access or Excel) would work best?

    Thank you in advance for your replies!

  2. #2
    Senior Member RickDev's Avatar
    Join Date
    Jul 2005
    Melbourne, Florida
    Posted a reply in the other forum
    "Nobody knows what I do until I stop doing it."

    Florida Web Design | Online Geek Hangout | Office Pranks and Humor

Similar Threads

  1. Importing .csv contacts into Evolution
    By JoeyJoeJoe in forum Linux - Software, Applications & Programming
    Replies: 0
    Last Post: 05-05-2007, 03:01 PM
  2. Duplicate emails after importing pst
    By jonfa in forum Windows - General Topics
    Replies: 0
    Last Post: 08-04-2006, 09:06 AM
  3. Importing Spreadsheets
    By Dannoboone in forum Windows - General Topics
    Replies: 3
    Last Post: 07-24-2005, 07:19 PM
  4. Error Importing XML Files
    By regix in forum Windows - General Topics
    Replies: 0
    Last Post: 01-04-2005, 01:48 AM
  5. Importing old thunderbird e-mail
    By mcdougrs in forum Linux - Hardware, Networking & Security
    Replies: 3
    Last Post: 10-29-2004, 01:31 PM


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts