T
Todd F.
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.
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.