Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I get Pivot Tables to recognise time formatted data
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 "Cadelin" wrote in message ... 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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting time-formatted to text-based data | Excel Discussion (Misc queries) | |||
conitif doesn't recognise time format? how to get round this? | Excel Worksheet Functions | |||
Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel | Excel Worksheet Functions | |||
pivot tables - how can i set one up with data points over time? | Charts and Charting in Excel | |||
Conversion of Cross-Tab Formatted data to qualify for Pivot Table | Excel Discussion (Misc queries) |