Apply a formula as a pivot table calc or suggestion
 

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

Apply a formula as a pivot table calc or suggestion
 

Why don't you just format the cells of interest to dd:hh:mm???

"Todd F." wrote:

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

Apply a formula as a pivot table calc or suggestion
 

Barb thanks for replying - I cannot use that format due to the number of days
exceeding 30 or 31 - it won't count past that and I have some that exceed 300
or 400 days

Any other thoughts woul dbe appreciated

"Barb Reinhardt" wrote:

Why don't you just format the cells of interest to dd:hh:mm???

"Todd F." wrote:

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