I have this wonderful calculation I was shown that converts days , hrs,
minutes in decicmal form to ddd:hh:mm for example:

1.25 days = 1:06:00
0.125 days = 0:03:00
40.625 days = 40:15:00 - note must be able to go up to 3 or 4 hundred days

The formula I am using ( with help) is: ( assume "A1" is the value)

=INT(A1)&":"&TEXT(A1,"hh:mm)

so I tried to put this into my pivot by replacing the A1 but no luck

I need to apply this calc to an average , a min, and a max pivot summary
field.

Any thoughts - I am open to any suggestions ifd I am approaching not the
best way.

The goals is to get a pivot with ddd:hh:mm not 1.something.