+ Reply to Thread
Results 1 to 2 of 2

Calculating Work and worked hours using Pivot

  1. #1
    Forum Contributor
    Join Date
    02-23-2014
    Location
    Melbourne
    MS-Off Ver
    Microsoft 365
    Posts
    174

    Calculating Work and worked hours using Pivot

    Hi Experts
    I need some help creating some pivot tables
    I have a worksheet, called Daily Production Report, with data on what work was done on what day
    What I need is a pivot table that will show me all the Prod.Ord build on a given day and the remarks
    Another pivot that will show me the Allocated Time, Total Time and Value Built on a day
    The data is filtered using a timeline and slicer
    A pivot table that will show me the total hours worked and the employee Name who were present on the day

    Please refer to attached
    Thanks in Advance
    Rahul
    Attached Files Attached Files

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,910

    Re: Calculating Work and worked hours using Pivot

    What does the Total Time column represent? It looks like it is supposed to be minutes worked but it does not agree with the start and end time. For example, row 9: 1:30 PM to 3:30 PM is 120 minutes but the Total Time shows 110 minutes.

    Ignoring that, I built a pivot table that calculates the time by En Time - Start Time.
    Attached Files Attached Files
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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. Replies: 8
    Last Post: 09-30-2017, 07:00 PM
  2. Replies: 5
    Last Post: 09-13-2017, 02:08 PM
  3. Calculating hours worked daily, weekly, monthly in a pivot/slicer
    By pini37 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-22-2016, 10:11 AM
  4. Replies: 0
    Last Post: 05-14-2012, 05:36 PM
  5. Calculating basic hours worked, between a time range and premium hours worked
    By RoyLittle0 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-07-2012, 06:59 AM
  6. Replies: 0
    Last Post: 01-05-2012, 06:23 AM
  7. Calculating hours worked by duration - Pivot Tables
    By Daniel Black in forum Excel General
    Replies: 2
    Last Post: 07-08-2009, 07:29 AM

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