Hi Folks,

I am stumped as to limiting an "if" statement in my payroll spreadsheet.

basically, my wage rate is as follows...
* straight time (8 hrs.)
* time and a half after 8, till 10 hrs. (2hrs.)
* double time after 10

my problem is with limiting the "time & a half" collumn to 2 hrs.

D7=IF(B78,B7-8,0)

I'm not sure I'm being coherent with what I'm trying to relate to this
group, so I uploaded a sample of what I've got to the web for your viewing.
http://home.att.net/~thegeeze/

Any insight you could provide would be greatly appreciated.

thx