Hi,

Here is a shorter version:

=SUM(COUNTIF(B2:H2,{"Va??";"d";"n"})*12)

If you already have the above calculation in cell I2, then Regular hours in
J2 would be
=MIN(I2,48)
and Overtime hours in cell K2 would be
=MAX(I2-48,0)

If this helps please click the Yes button

Cheers,
Shane Devenshire

"Kris M" wrote:

I GOT IT TO WORK THANKS SO MUCH -- I JUST EXPANDED ON WHAT YOU SHOWED ME BUT
NOW ANOTHER FUNCTION QUESTION PLEASE?

if we work a standard 48 hour work week and work overtime by 24 hours, what
kind of function can you toss my way to show that?

what I mean is in a table i need the first column to read the total hours
worked (example is 12, 72,60,72) in the second column i need to show the
hours that went OVER the standard hours of 48 (doing the math the hard way --
0,24,12,24)

i just confused myself so no biggie if i lost you somewhere.

"Kris M" wrote:

actually i need "va-d" and "va-n" to also have a value of 12 -- "vac" and
"off" obviously have a zero value.

"Mike H" wrote:

How about this in I2 and drag down

=(COUNTIF(B2:H2,"D")+COUNTIF(B2:H2,"N"))*12

You didn't say what was to happen for - va d or va-n

Mike

"Kris M" wrote:

I'm working on a schedule that needs to count N or D and assign it a value of
12

the chart i'm working with looks something like this

sun mon tues wed thurs fri sat
mary vac vac vac vac vac va d va-n
tyler off off n n d d off
john d d d d off off d
joe n n off off n n n


what function can i use to count how many times a person works "n" or "va d"
or "va-n" or "d" and assign a value of 12 for each of those characters but a
value of ZERO for off or vac?