ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Still needing help with a pivot report (https://www.excelbanter.com/excel-discussion-misc-queries/150419-still-needing-help-pivot-report.html)

Lorie

Still needing help with a pivot report
 

I have a pivot report, that I am counting minutes worked on....
Total time worked (End time - Start Time) =(C2-B2)*1440
Some of the time is billable - (Activites 1 - 4 are billable) =(F2<4)*I2
Some time is not billable - (Activite 5) =(J2<1)*I2

7:00 AM 9:05 AM 5 125 0 125
9:05 AM 9:45 AM 3 40 40 0
9:45 AM 10:10 AM 5 25 0 25
type of work Total Billable non
billable
But when I pivot it, I don't get the correct data... I get a 1 for time
that is billable and a 1 for time that is not billable, yet the total
billable works..... see below....

Total Billable & Non-billable Min. =190 minutes worked
"Total Billable Minutes 1-4" Are equaling "1" for minutes billable
"Total Non-Billable Minutes 5" Are equaling "1" for minutes non
billable

can you help me figure out what is going wrong? What I might need to fix?
I am now at a loss......


--
thank you, Lorie


All times are GMT +1. The time now is 12:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com