Results 1 to 8 of 8

Pivot Table Help

Threaded View

  1. 09-20-2023, 04:45 AM #1
    Rachidlea
    Rachidlea is offline
    Registered User
    Join Date
    06-26-2013
    Location
    UK
    MS-Off Ver
    Microsoft 365 Entreprise
    Posts
    33

    Post Pivot Table Help

    Hello all,

    I am trying to calculate the time spent for each particular STATUS but when i do my pivot table (SHEET 7) it counts 12min compared to the reality from SHEET 5 where it should be 47min.

    can you please help on this.

    i have attached the excel as well
    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. [SOLVED] Pivot table - filtering a field in source table isn't giving expected results in pivot tbl
    By sharbie in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 07-01-2019, 08:01 AM
  2. [SOLVED] VBA create pivot table in excel 2010 defaulted to 2003 pivot table format
    By lynnsong986 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-15-2019, 02:05 PM
  3. Adding additional columns inside a pivot table to calculate rates from pivot table
    By yehb in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 02-27-2017, 07:41 AM
  4. Table to column problem to create dataset for pivot table [Bloomberg data to pivot table]
    By fajfus in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 01-24-2017, 06:56 PM
  5. creating a table that will link to a pivot table and change as the pivot table is changed
    By MP6645 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-29-2015, 05:19 PM
  6. creating a table that will link to a pivot table and change as the pivot table is changed
    By MP6645 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-29-2015, 05:15 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