![]() |
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