+ Reply to Thread
Results 1 to 6 of 6

Timesheet template design

  1. #1
    Registered User
    Join Date
    05-22-2016
    Location
    Sydney
    MS-Off Ver
    2013
    Posts
    4

    Timesheet template design

    Hi All

    Just need some help in designeing a timesheet template.

    We have quite a few projects ( around 40) at this moment, also it continue closed and new project get started

    Also we got around 50 project manager working on different projects in different states .Need to design a time sheet template for project manager to fill out the time sheet themselves,but also easier for me to allocate their time to different project

    Could someone please help on this?

    Thanks
    Scott

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,938

    Re: Timesheet template design

    Hi, welcome to the forum

    If you want it custom-built, you will need to start by showing us samples of what you want.

    Otherwise, try a google search?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    05-22-2016
    Location
    Sydney
    MS-Off Ver
    2013
    Posts
    4

    Re: Timesheet template design

    Sounds good idea,just wondering howcan I upload a file orscreenshot?

  4. #4
    Registered User
    Join Date
    05-22-2016
    Location
    Sydney
    MS-Off Ver
    2013
    Posts
    4

    Re: Timesheet template design

    TEMPLATE.png
    This is the current template ,the problem here is there are so many projects coming in and out and so many project manger working on different projects. I feel it is quite hard to add up together the State total hours for all prject manager. Could someone please provide a direction?

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,938

    Re: Timesheet template design

    Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
    Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

    Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.

  6. #6
    Registered User
    Join Date
    05-22-2016
    Location
    Sydney
    MS-Off Ver
    2013
    Posts
    4

    Re: Timesheet template design

    Thanks for you r help.I have upload the sample workbook.

    Could someone please take a look and shed some light?

    I have uniform all the project name and put it as drop down list for PM to choose. Just do not know how to design the sum up total in changing environment( the project keep coming in and out)

    Much appreciate any kind of help

    Regards
    Scott
    Attached Files Attached Files

+ 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. how do i design template ?
    By lancer12 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 04-18-2006, 05:25 AM
  2. [SOLVED] Design New Template
    By Larry-Laser in forum Excel General
    Replies: 7
    Last Post: 04-08-2006, 03:30 PM
  3. [SOLVED] Bi-Weekly Timesheet Template
    By Janice@CIDMCE in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-05-2006, 01:40 PM
  4. Excel Timesheet template
    By Asphalt in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-24-2005, 07:05 PM
  5. Template design and consolidation
    By CaymanCarrie in forum Excel General
    Replies: 0
    Last Post: 10-10-2005, 02:05 AM
  6. HELP!I need a specification template purchasing Interior Design it
    By Anne Troy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 06:05 AM
  7. HELP!I need a specification template purchasing Interior Design it
    By designer in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  8. HELP!I need a specification template purchasing Interior Design it
    By designer in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-06-2005, 12:05 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