+ Reply to Thread
Results 1 to 2 of 2

Pivot tables with data in HH:MM:SS

  1. #1
    Forum Contributor
    Join Date
    11-04-2015
    Location
    Copenhagen, Denmark
    MS-Off Ver
    2010
    Posts
    114

    Pivot tables with data in HH:MM:SS

    Can I use data formatted in HH:MM:SS in pivot tables?

    Currently, the table does not provide the proper result?

    Should I define the data another way?

    I have attached an example of the data I have.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: Pivot tables with data in HH:MM:SS

    custom format [hh]: mm
    Attached Files Attached Files

+ 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. Filtering data from tables using pivot tables
    By DaddioPlus in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 03-05-2015, 01:25 PM
  2. Validating Data Between 2 Pivot Tables (Pivot Tables Don't Line Up)
    By JohnGC84 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-18-2013, 05:07 PM
  3. Complex Request with Pivot Tables and copying pivot data to new page with formulas
    By Obsessed in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-07-2013, 09:16 AM
  4. Copying pivot tables as data tables with formatting
    By wolis in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-17-2012, 12:57 AM
  5. Replies: 3
    Last Post: 02-27-2012, 08:03 PM
  6. Creating data tables from a database without using pivot tables
    By gareth.campbell in forum Excel General
    Replies: 4
    Last Post: 11-24-2010, 12:23 PM
  7. Change Variable data on 1 pivot table, make same changes in other pivot tables
    By matt4003 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-05-2008, 10:55 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1