+ Reply to Thread
Results 1 to 2 of 2

Seeking some suggestions to improve my timesheet

  1. #1
    Registered User
    Join Date
    05-11-2009
    Location
    Belfast
    MS-Off Ver
    Excel 2010
    Posts
    65

    Seeking some suggestions to improve my timesheet

    Gurus of excel.
    Before I start I have attached an example sheet for better understanding.

    I am building a timesheet to track the following:
    • Total Time worked.
    • Time worked over 40 hours
    • Breakdown of the type of work undertaken.
    • Holidays taken
    • Total time less holidays.

    I am using a SUMIF to get bulletpoints 1 & 3
    Formatting seems to be letting me down for Time over 40 hours

    I want to know if there is a simple way of discounting the holiday hours? Although this sample is basic and shows only holidays I also have to include flexi time taken etc.
    Attached Files Attached Files

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Seeking some suggestions to improve my timesheet

    Hey Jaywizz,

    See if a Pivot Table type of answer makes your work easier.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ 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. Seeking Help with Excel
    By magnus3301 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-10-2012, 07:47 PM
  2. Replies: 0
    Last Post: 04-27-2010, 04:24 PM
  3. Re: Seeking Help with a forumal.
    By Randy Harmelink in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-07-2006, 05:45 PM
  4. Suggestions to improve UDF
    By MrShorty in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-06-2006, 12:22 PM
  5. Seeking help from a GURU
    By usf97j4x4 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-11-2006, 01:17 PM

Tags for this Thread

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