| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula/ calculation in pivot table
I am using Excel 2003. I have a spreadsheet that has columns for"Time
Started", "Time Finished" & use these to calulate "Time Taken". In my pivot table I need to know how many activities took longer than 10 minutes and how many were either equal to or less than 10 minutes. The data in the spreadsheet is imported from another system and changes daily. Have been battling with this for hours now @ would appreciate any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I have a different formula in a subtotal column in Pivot Table | Excel Discussion (Misc queries) | |||
| pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
| How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
Threaded Mode
