Results 1 to 7 of 7

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

Threaded View

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

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

    Dear Forum-

    I would greatly appreciate any assistance in a way to accomplish my goal with a spreadsheet.

    I'm trying to make a running, daily log, where the user is presented with a drop down list of activities to choose from, and then they just need to put the date, and how long they did that activity. So in a given day, they may have 3 or 4 entries, with various activities and times allotted.

    Then I would like it to calculate how many times they have done each activity, and how many hours they have done each activity, in total.

    I have a visual backbone (attached) of what I'm trying to do, and I can get my "IF" statements working for a singular activity, but as far as counting the number of each activity, is where I the wheels fall off for me, among other issues!

    For example, I can successfully do an IF function, say IF cell "blank" equals "someactivity" then return a "1", if not, return a "0". I guess I would like to know if you can do an IF function that will check for multiple values... and then give you a count for each one going down the log? Or am I just going to have to do a billion hidden function cells that will eventually do all the math behind the scenes.

    I've attached what I have so far and hopefully it's not too pitiful.

    Thank for any help!

    Sincerely,
    Jim
    Attached Files Attached Files

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