How to get pivot table Time field to appear correctly

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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'?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table with Data Model Connection - getpivotdata reference issue 0
Peculiar default cell format 1
Pivot Table sorts date as Alpha, not as Date 6
Average of Subtotals in Pivot Table 0
Pre-configuring Pivot table "views" 4
Sorting the pivot table field list 4
Size of file with pivot table 2
Link Drop Down with Pivot Table 2

Back
Top