View Single Post
  #5   Report Post  
Gord Dibben
 
Posts: n/a
Default

Sandoval

See Chip Pearson's site for working with timesheets and overtime.

http://www.cpearson.com/excel/overtime.htm


Gord Dibben Excel MVP

On Wed, 14 Sep 2005 11:21:01 -0700, "Sandoval"
wrote:

I am trying to make a document that is a daily processing cost for my
supervisor. It is actually in week form. I need to times the daily rate by
hours worked for the day. Once the employee has reached 40 hours i need to
times the daily rate by time and a half and then by how many hours worked
overtime and sometimes these are all in one day. So lets say one employee
worked 45 hors after 4 days that 4th day i need to minus the overtime hours
from the regular hours and then times the daily rate. PLEASE someone help me.