Please see the attached spreadsheet/pivot. I've spent hours searching for a solution to what seems to be a simple problem. I'd like to add a column to this pivot that calculates the difference between the first login and the last logout (existing columns) - ultimately providing the number of hours spent "in the system" or at work. I can't get calculated fields to work when using the Min and Max formulas. Nor does the calculated item work.
Thank you,
anthonycoz
Bookmarks