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 ? |
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 ? |
All times are GMT +1. The time now is 02:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com