I am trying to create a Pivot Table that will show the Providers, their Time In and Time Out of their respective Clinics. Somehow, the pivot table is not showing the correct times for either Time In or Time Out, and I never experienced such a wild result from a pivot table before. I attached the file to this message so that any interested responders could see what I mean. Is there something that I can do to enable me to see the times as they are in the the Source Data?
Many thanks for any and all help in this frustrating matter.
Bookmarks