I have a pivot of times, 8:00, 8:15, 9:00, 9:30, etc.... My pivot table groups them as 8 & 9, great, but when you expand the section instead of seeing 8:00 or 8:15, you just see :00, :15.
Is there way to get it to list the full time?
I have a pivot of times, 8:00, 8:15, 9:00, 9:30, etc.... My pivot table groups them as 8 & 9, great, but when you expand the section instead of seeing 8:00 or 8:15, you just see :00, :15.
Is there way to get it to list the full time?
I was unable to reproduce your error, so please attach a sample workbook
- Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.
- Make sure that your desired solution is also shown (mock up the results manually).
- Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).
- Try to avoid using merged cells as they cause lots of problems.
Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.
OK. I uploaded a workbook. First sheet is the pivot table with a note showing what I am referring to. Sheets 2/3 can be ignored. Sheet 4 is the original data.
Trying to stop it from showing time as
11 AM
+ :10
and instead show
11 AM
+ 11:10
You had grouped the field PUNCH into Minutes and Hours, thus creating a new field titled HOURS2.
- HOURS2 represents the hours
- PUNCH represents the minutes.
To fix this - on the pivot table, right click on the PUNCH field and select UNGROUP
Update:
The info above stands as-is but, if you want to achieve the 11 AM & 11:10, then I suggest that you duplicate the PUNCH field and call it PUNCH HOUR
Next you could do the group set but just pick hour.
See attachment
Last edited by Syrkrasi; 11-16-2017 at 03:51 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks