P
pgronowski
I have a spreadsheet with a job start date, hourly rate and weekl
hours. I would like to calculate the total revenue for each month.
i.e. determine the revenue between 7/1/2012 and 7/31/2102.
For example below all 3 people are working in the month of July, bu
what is their revenue just for July?
A B C D
E
Job SD Job Ending Date Hourly Wage Hours Revenue/Week
1/8/2013 $7.80 25.00
$195.00
4/12/2013 7/15/2013 $7.25 22.00 $159.50
7/3/2013 $8.00 40.00
$320.0
+-------------------------------------------------------------------
|Filename: Example.jpg
|Download: http://www.excelbanter.com/attachment.php?attachmentid=903
+-------------------------------------------------------------------
hours. I would like to calculate the total revenue for each month.
i.e. determine the revenue between 7/1/2012 and 7/31/2102.
For example below all 3 people are working in the month of July, bu
what is their revenue just for July?
A B C D
E
Job SD Job Ending Date Hourly Wage Hours Revenue/Week
1/8/2013 $7.80 25.00
$195.00
4/12/2013 7/15/2013 $7.25 22.00 $159.50
7/3/2013 $8.00 40.00
$320.0
+-------------------------------------------------------------------
|Filename: Example.jpg
|Download: http://www.excelbanter.com/attachment.php?attachmentid=903
+-------------------------------------------------------------------