View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cadelin Cadelin is offline
external usenet poster
 
Posts: 1
Default How can I get Pivot Tables to recognise time formatted data

I am attempting to construct a pivot table to sum time spent on a phone bill.
The source data is in HH:MM:SS format yet the pivot table shows a zero when
performing the sum function.

Why or how can I overcome this and actually get the pivot table to correctly
add up the time to show an answer in total HH:MM:SS format ?