Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I program this needed format conversion AFTER pivot table
I need a convedrsion after each pivot table is built or refreshed I think !
I have days presented in decimal format 1 day =1.0, 380 & 1/2 days = 380.5, 12hrs = 0.5, etc. I desparately need to convert this data to Days:hrs:minutes in pivo tables I only need the summary in the pivots to show this dhm format - I still keep the decimal format in the data to do various other calcs The follwing formula is what I need to incorporate into the pivot table - can this be done via vba. INT(targetcell)&":"&text(target cell,A1"hh:mm") Please help! anybody thanks for your time |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Help Needed!!!! | Excel Discussion (Misc queries) | |||
Program a button to copy a pivot table and then email | Excel Discussion (Misc queries) | |||
Macro Needed for Pivot Table | Excel Programming | |||
Conversion of Cross-Tab Formatted data to qualify for Pivot Table | Excel Discussion (Misc queries) | |||
Pivot table help needed | Excel Programming |