Results 1 to 7 of 7

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

Threaded View

  1. 09-02-2018, 11:57 AM #5
    DukeDiablo
    DukeDiablo is offline
    Registered User
    Join Date
    03-06-2011
    Location
    Virginia, USA
    MS-Off Ver
    Excel 2010
    Posts
    17

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

    Well I quickly realized I'm not smart enough for pivot tables and elegant solutions... so I went caveman on it, but so far it is working as I wanted.

    I've attached the solution I went with, thanks for all the help and advice, I was just
    in a hurry and needed to get something that worked right away that I could understand.

    Yall have a great week and thanks again.

    -Jim
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to create a formula(s) that calculates the "business hours/days" between timestamps
    By h2holbro22 in forum Excel Formulas & Functions
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1