How would you show this in a piviot table?

L

Lorie

I want my pivot report to total all billable and non billable minutes for one
client,
in other words the bill able minutes are 150+90 in this case, which equals 240
We bill in 15 minute units, in this case, 240/15=16 units that i can bill on.

How would you show this in a piviot table? I hope i am being clear?


Billable Minutes 150
Non-Billable Minutes 0
Billable & Non-billable Minutes 150
_______________________________
Billable Minutes 90
Non-Billable Minutes 25
Billable & Non-billable Minutes 90
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

i need to seperate total time from billable time & non billable ti 7
Using Pivot table to fill spreadsheet by date 0
Complex IF Statement 5
piviot calcualtions 1
Making a comparison to reach a calculation??? 1
how can I multiply number of hours and minutes by hourly rate? 5
Calculations in Crosstab Report 0
Pivot reports 0

Top