Results 1 to 7 of 7

Trying to make a "Daily Log Sheet", that calculates number and hours for activity

Threaded View

  1. #6
    Registered User
    Join Date
    03-06-2011
    Location
    Virginia, USA
    MS-Off Ver
    Excel 2010
    Posts
    17

    Question Re: Trying to make a "Daily Log Sheet", that calculates number and hours for activity

    OK, I have a new problem, The Daily Log is working great (blank version attached), but now my supervision also wants to be able to have us turn in a weekly stat sheet... in addition to the quarterly and yearly sheets.

    I've added a "Weekly Log Generator" tab... which I was hoping I could do some magic with as follows:

    The user would enter in the beginning and ending date of the particular work week they want to generate a report for... and then the stat sheet would be filled out appropriately on that tab, so they could print it out.

    Given my current caveman spreadsheet setup, any ideas on how to accomplish that without starting from scratch? I'm sure I should have gone with the data table suggestion early on!

    Thanks for any help!

    -Jim

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 03-24-2016, 08:21 AM
  2. [SOLVED] Need Help with formula to calculate "hours scheduled" based on employee's number
    By Dnakr in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-11-2014, 02:56 PM
  3. [SOLVED] How to Add timesheet daily hours activity wise
    By zurkal in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-12-2012, 06:03 AM
  4. [SOLVED] Can't make autofilter find the number "1" and not "10"
    By PBChristensen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-25-2012, 08:18 AM
  5. [SOLVED] How to Count number of "Error" and "OK" after the word "Instrument" found in table row
    By eltonlaw in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2012, 06:26 AM
  6. If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ...
    By Maria J-son in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2006, 08:25 AM
  7. How can I make a number e.g. "14" appear as a word e.g. "fourteen.
    By Gil in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-25-2005, 05:43 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