I have a formula to convert decimal days to Days,Hours,minutes

So 1.5 days would read as 1:12:00

The formula is : "=INT(target cell)&":"&TEXT(target cell,"hh:mm")"

I need to apply this formula to pivot table summaries either as incorporated
pivot calc or worse case will need to manually apply to pivot table data
after pivot killed and data just values and not live pivot.

So I basically have a list of different day vlaues such as

1.25 1.5 2.654 370.825
24.45 18.768 19.35 120.89

Any thoughts - thanks