Apply a formula as a pivot table calc or suggestion

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top