How can I get Pivot Tables to recognise time formatted data

C

Cadelin

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 ?
 
B

Bernie Deitrick

Cadelin,

You are probably working with string values that look like times. Try using

=TIMEVALUE(E2)
or
=VALUE(E2)

where E2 is the first cell with the time values - copy down, then use that column as your PT data
source.

HTH,
Bernie
MS Excel MVP
 

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

Formatting time in a Pivot Table 1
### showing up in pivot table. 2
Pivot Tables - standard Data Field function 1
Pivot table questions 1
Pivot Tables & data changes 6
How can I change the source data reference to another pivot table? 2
Inputing data into Pivot Table 2
data in formula and how to use pivot table 4

Top