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