If statement help?
 

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.

=IF(a140,((a1-40)*payrate*1.5)+(40*payrate),a1*payrate)

"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.

David McRitchie has a macro that may do what you want:

http://www.mvps.org/dmcritchie/excel/insrtrow.htm
look for: InsertRowsAndFillFormulas

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

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.

--

Dave Peterson

Note

This answer should be posted for the posting above.

"Same formula in each cell of the column, etc."


Gord Dibben Excel MVP

On Wed, 14 Sep 2005 13:36:18 -0500, Dave Peterson
wrote:

David McRitchie has a macro that may do what you want:

http://www.mvps.org/dmcritchie/excel/insrtrow.htm
look for: InsertRowsAndFillFormulas

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

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.

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.

Oopsie.

Thanks for watching out!

Gord Dibben wrote:

Note

This answer should be posted for the posting above.

"Same formula in each cell of the column, etc."

Gord Dibben Excel MVP

On Wed, 14 Sep 2005 13:36:18 -0500, Dave Peterson
wrote:

David McRitchie has a macro that may do what you want:

http://www.mvps.org/dmcritchie/excel/insrtrow.htm
look for: InsertRowsAndFillFormulas

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

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.

--

Dave Peterson