Need help writing a formula!

[Tina Marie]

I have a workbook that tracks my employees time.

I need to be able to figure out how many hours to pay at regular rate, vacation rate, holiday rate and overtime. Vacation/Holiday time is not counted towards overtime.

Example. Col A = total number hours worked
Col B = total number regular (straight) time
Col C = total number vacation hours
Col D = total number holiday hours
Col E = total number overtime hours

I know there are a variety of ways to make the initial entry in Col A (include or not include vacation/holiday hours), how I do it is not as relevant as getting it done!

I welcome any assistance on this!

 

[PaddyD]

hi - welcome to the board!

not clear what your problem is - to me at least.

what do you need to do? my guess - fill in the other columns given some info in col A - in which case we need to know what sort of data is in col A, how ovrtime etc is identified...

lots more info please...

 

[DRJ]

Hi - welcome to the board

ok so you input A B and D right? And A in actual hours worked so it doesn't count vacation?

Then B1 is

=min(A1 - D1,40)

And E1 is

=if(B1 > 40 , B1 - 40, 0)