Can I program this needed format conversion AFTER pivot table

T

Todd F.

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
 

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

Dealing with a Pivot Table (when I don't want to) 0
Change SourceName on Pivot Table 0
pivot table loosing decimals (vba) 1
Retain pivot table formatting after refreshing data 0
Code that will rerun or refresh a pivot table (after new data ispasted into the original Pivot Table 3
Pivot table automation 1
Apply a formula as a pivot table calc or suggestion 2
Pivot Table - Changes 5

Top