Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
wccmgr
 
Posts: n/a
Default How to get pivot table Time field to appear correctly

I have created a pivot table that works as a scheduling tool. It uses a
'Time' field from the input data to populate the available times on certain
days in the pivot table. Mysteriously, the time of '1:00 PM' is now
appearing as 'n' in the pivot table field. The input data is keyed as
'13:00' military time. The pivot table had been showing the correct data on
the pivot table, but now, months later, is showing the 'n'. If I change the
time in the input table to '13:01', the pivot table will properly display a
formatted '1:01 PM' and sort the field correctly.
  #2   Report Post  
wccmgr
 
Posts: n/a
Default

The question is: How do I get Excel to show '13:00' in the input table
correctly as '1:00 PM' in the pivot table, and not the mysterious 'n'?

"wccmgr" wrote:

I have created a pivot table that works as a scheduling tool. It uses a
'Time' field from the input data to populate the available times on certain
days in the pivot table. Mysteriously, the time of '1:00 PM' is now
appearing as 'n' in the pivot table field. The input data is keyed as
'13:00' military time. The pivot table had been showing the correct data on
the pivot table, but now, months later, is showing the 'n'. If I change the
time in the input table to '13:01', the pivot table will properly display a
formatted '1:01 PM' and sort the field correctly.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I show all field data in a pivot table, instead of blank Alastair Scott Excel Discussion (Misc queries) 3 August 17th 05 07:08 PM
Group Field in Pivot Table €“ Not Enough Room Mary Ann Excel Discussion (Misc queries) 2 July 15th 05 08:22 AM
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis [email protected] Charts and Charting in Excel 0 July 13th 05 09:30 PM
Pivot Table Data Field Query Pepikins Excel Worksheet Functions 1 June 14th 05 10:58 PM
Pivot Table chart field buttons Jeff M Charts and Charting in Excel 1 April 9th 05 01:54 AM


All times are GMT +1. The time now is 07:41 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"