problems with parameters for overtime pay

[darcym]

I'm trying to complete a payroll for a friend. I'm running into problems when calculating over time.

firstly any hours worked on saturday or sunday are overtime
any time after 4 pm is overtime
and finally any hours after 40 per week are considered over time

I've added the first 2 parameters and am struggling to figure the 40 hours parameter. any help is much appreciated

enclosed is an attachment of what ive done thus far

when inputing time it must look like this - 8 am or 3:30 pm

[perimidt]

Hi

For the regular hours you can change the formula in B193 to:
=MIN(J175+J151+J125+J99+J73+J47+J19,40)

Then you could add an if-formula to the overtime hours in B192:
((J174+J150+J124+J98+J72+J46+J18)*24)+IF((J175+J151+J125+J99+J73+J47+J19)>40,(J175+J151+J125+J99+J73+J47+J19)-40)

Best regards
Per Erik

[newdoverman]

Here is a simple hour/payroll workbook that I have been building over time. Maybe you can get some ideas from it.

Forgot to add that the password is blank...just hit enter at the prompt

[darcym]

I fixed the formulas for the weekly totals as perimidt suggested and it works correctly for weekly totals. however i need to be able to look at a certain days hours as well and see the correct amount of overtime worked on a specific day and the parameter about anytime after 40 hours being overtime only comes into effect during the weekly totals

for example in the attachment thursday should be 4 hours regular and 8 hours overtime and friday should be all over time.