+ Reply to Thread
Results 1 to 1 of 1

Averaging the start and ending time in a pivot table

  1. 08-11-2016, 04:51 PM #1
    HJHamm
    HJHamm is offline
    Registered User
    Join Date
    07-18-2014
    Location
    Atlanta, GA
    MS-Off Ver
    10
    Posts
    65

    Averaging the start and ending time in a pivot table

    I am having an issue trying to figure out how to average the start time of employees during the week within a pivot table.
    In the attached example Willie should have an avg start time of 7:37:12 PM (removing the 1:35:00 AM start time). But the pivot table says he has a 9:25 PM avg start.
    Any clue why the avg time is all over the board?
    Thanks in advance for the help!
    Attached Files Attached Files
    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. [SOLVED] Pivot Table - Averaging Issue in Column
    By othaVada in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-28-2015, 05:39 PM
  2. Pivot Table with Margin % not averaging correctly in the Grand Total row
    By plguard in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-22-2013, 02:22 PM
  3. Pivot Table Averaging Formula Question
    By samjkent1 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 07-11-2013, 05:34 PM
  4. [SOLVED] Adding and then averaging data in a pivot table
    By TK5 in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 01-17-2013, 02:59 PM
  5. Excel 2007 : Elaped military time when actual start time before scheduled start time
    By cro1010 in forum Excel General
    Replies: 3
    Last Post: 03-27-2012, 01:07 PM
  6. Averaging a column of calculated fields in pivot table
    By me19708 in forum Excel General
    Replies: 1
    Last Post: 06-04-2007, 01:53 PM
  7. Averaging Grouped Data - Excel 2003 Pivot Table
    By WrinkledCheese in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 12-09-2006, 07:20 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