Results 1 to 7 of 7

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

Threaded View

  1. 08-24-2018, 12:33 PM #3
    istank
    istank is offline
    Registered User
    Join Date
    06-12-2017
    Location
    Pittsburgh, PA
    MS-Off Ver
    365
    Posts
    16

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

    I think a data table and a pivot table(s) built from that for reports will solve your dilemma. You can record all entries in one spot and just create a pivot table for a report as needed. I have (hopefully) attached your sheet with 2 new tabs at the end as an example.
    Attached Files Attached Files
    Try, fail/succeed, and learn.
    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