ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   complicated calculation in my pivot table (https://www.excelbanter.com/excel-worksheet-functions/79055-complicated-calculation-my-pivot-table.html)

Todd F.

complicated calculation in my pivot table
 
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.





All times are GMT +1. The time now is 08:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com