Is the ### due to insufficient column width, or a negative time? If the
former, you'll just need to increase the width. If the latter, you need to
adjust your formula, or change the format, as XL can't display negative times.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Judy" wrote:

My data has a col called Dur which is a calculation subtracting one time from
another time. Depending on my filtering in the pivot table depends on how
many cells contain ###. I have the data formatted as General and Dur in the
PT is formatted as custom [h]:mm:ss
Any assistance with getting my data to show up as hh:mm:ss to replace the
### would be appreciated.
--
Thanks,
Judy