Excel: calculating hours worked on shift

I'm thinking this is a pretty easy one. I am doing a new schedule at work and if the total number of hours in a work week are greater than 80, then it will need to be calculated with overtime. basically what I am trying to think of is; the result is 84, then 80*x=y, then the 4 remaining hours would be 4*1.5x=w, then add them together to get a total, y+w=total earnings anything over 80 would be time and one half. I am using this formula to count the days worked, 1 being first shift and 2 being second shift; =(SUM(COUNTIF(I13:V13,{1,2}))*12)

This question generated 19 answers. To proceed to the answers, click here.

This thread is current as of April 29, 2015.

For more resources for Microsoft Excel