LinkBack URL
About LinkBacks
Thank you again. Would you by any chance have a suggestion on how to create a function for the pivot table that would not count the the gap time if exceeds more than 5 hours?
Thank you again. Would you by any chance have a suggestion on how to create a function for the pivot table that would not count the the gap time if exceeds more than 5 hours?
I don't have time at the moment to look at this in detail I'm afraid but off hand a quick solution may be to alter source data (Gap Time column) such that:
L3:
=IF((F3-H2)>TIME(5,0,0),"",F3-H2)
copied down
Refresh the PT (you will of course get DIV/0 error on the PT if there are no entries for a given day that are less than the 5 hour threshold)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks