View Single Post
  #1   Report Post  
Myrna
 
Posts: n/a
Default Cell Formula Help

I have 5 employees.
How would you write this formula to calculate time and 1/2 over 40 hrs. in a
single week if even over 40hrs for the week and then calcuate the same for
the second week then figure the single day also.

B5 to H5 is 1 week, I5 to O5 is 2nd week, P5 is a single day. S5 = total
hours. T5 is Gross Pay = total hours x 8 an hr.
Myrna
--
Thank you