I am trying to create a spreadsheet to calculate employee hours.
We use 100 minutes instead of 60. (Ex 15:50 = 3:30)
We round based on 5's to the hour (Ex 9:92 = 10 9:90 =9.75)
Overtime is calculated by weekly Hours, Not Daily

I need to sum column P if values in column A begin with 000.
any ideas?

is it possible to average the filtered values only?

I'm summing several columns of data in a pivot table with multiple rows.  Is
it possible to set up the pivot table to also display the division of 2 cells
of data in the same row.  I want to view the summed values and also see the %
value in a separate column.  Is it possible to ...

Good morning –
Have searched this and can’t quite figure it out.
I have a column containing 1122 numbers. They are unique numbers.
I have another column that contains 359 of those 1122 numbers. How can I

I need a macro to look at worksheet "Mar 08" starting in Column "C6" look
down the column and if there is a 0,1,2,3,4 the return the amount in column
"G" to worksheet "Summary" starting in column "C6" fill down, then look at
the same worksheet and if there is a 5,6,7,8 then look ...

Is there a way I can have a macro look at a worksheet and look down a certain
column, if the number in that column is x then return the value of a certain
column.
For example:

I have a sheet that prints price tags.  I want the price tage to be 1 of 7
colors.  I am using these conditional formats to get 3 colors.... I need 7.  
Any ideas?
Formula is  =VLOOKUP($A$4,Data,5,FALSE)="Motorola"

Column A contains 5-digit codes.  The third digit is a distance code, and I
want to sum entries in column C if the third digit is 4, 5 or 6.  The only
other codes for the third digit are 1, 2 and 3, so I can use ">3" since there
won't be anything over 6.

Can someone please give me the formula for a cell to match what the page
header or footer says?
Thanks!

Hi google groups?
I have been searching online to find a way to make a count by two
criteria - year and Y/N.  In all the searching it seems I have to do a
sumproduct, and wrote the formula below.  When I do countifs for each

I want only to allow text entered with a "/" character in the middle
of the cell. From 0/0 to 99/999 how do I do this?

For a given Year and Month, I need to find either the 3rd Sunday (if month =
Jan thru Oct) or the 2nd Sunday (if month = Nov or Dec).
Example:
Year = 2009

Is there a way to set a worksheet to show who makes any changes to it? Kind
of like how when you insert a comment, it will show the user that wrote the
comment?

Please can someone help.
I have been using the following formula  =SUMIF(B4:B35,">3",F4:F35)
Column B is the gas % and column F pressure so it would add up all the
pressures of gas more than 3%.