+ Reply to Thread
Results 1 to 2 of 2

Excel Pivot table Time Values is not populating same as Source Sheet

  1. 12-27-2023, 02:09 PM #1
    krish.Kommineni
    krish.Kommineni is offline
    Registered User
    Join Date
    12-27-2023
    Location
    DAllas
    MS-Off Ver
    Latest
    Posts
    1

    Excel Pivot table Time Values is not populating same as Source Sheet

    Hello Excel Experts, I am not able to Populate Time Values from my source sheet. Even I need to Sum up Time values in Pivot Table to show grand total. can you please help me or guide me to achieve this. very thank you in Advance
    Attached Images Attached Images
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-27-2023, 02:28 PM #2
    popipipo
    popipipo is offline
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,293

    Re: Excel Pivot table Time Values is not populating same as Source Sheet

    Column Y is a text value that looks like a time value.
    Try 'TEXT TO COLUMNS' to change it to real time value
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. Pivot Table with data source in another sheet looks for it on external source.
    By SAI80 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-23-2020, 05:45 PM
  2. To import the sheet into the excel workbook where I want to modify Pivot table source data
    By Farrukh253 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-05-2015, 02:14 AM
  3. Run time error '1004' when populating pivot table
    By Orongo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-22-2012, 07:29 AM
  4. Populating data source for pivot table
    By akaponem in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-31-2012, 04:12 AM
  5. Excel Pivot table values not matching data source
    By 4am in forum Excel General
    Replies: 1
    Last Post: 03-06-2012, 02:02 PM
  6. Excel 2007 : How to change excel 2007 pivot table data source to another pivot table?
    By blueycool in forum Excel General
    Replies: 1
    Last Post: 06-22-2010, 09:10 AM
  7. How to change data source of Excel 2007 pivot table to another pivot table?
    By blueycool in forum Excel General
    Replies: 1
    Last Post: 06-20-2010, 04:00 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1