View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.setup
tb
 
Posts: n/a
Default I want to set up a time sheet?

I want to setup a time sheet for 20+ employees, with the breakdown of regular
and overtime hours with calculations weekly.

I currently have a weekly time sheet with all employees, hours they worked
daily for the week, then a column that totals all the hours and calculates
the total with their wage.

I need some formulas to help me setup a column that will calculate over and
beyond for o.t. hours then add all totals together.

Am I asking for to much? I did play and set one worksheet up but it is
pretty complex. Is there possibly some samples or templates I can look at? I
did look in office templates but nothing I am really looking for.

Thanks
t