7 Replies Latest reply on Aug 25, 2016 2:33 AM by JonasGysin

Hours Multiplied by pay rate

Hi All,

I have a timesheet of which I am trying to calculate, here goes:-

In our business we have flat rate (8hrs working Monday - Friday),Time & Third rate (weekdays after 8 hours), Time & Half rate (Saturday working) & Double Time Rate (Sunday working).

I want to calculate the total hours into each separate box so I can then add a rate ie

Example

An engineer was working on a Monday and he worked 10:00 hours , 8 of those hours would be at a flat rate and 2 hours would be at time and a third rate. What is the calculation.

I currently have on my layout

Total Hours (which is a calculation of start time and finish time) this works!

Field: Flat Hours

Field: T 1/3 Hours

Field: T 1/2 Hours

Field: Double Time Hours

Any Ideas?

• 1. Re: Hours Multiplied by pay rate

HI Chris,

So to recap, you have:

rate 1 : mo-fr, first 8 h, 100 %

rate 2 : mo-fr, >8h; 133%

rate 3 : sat, 150%

rate 4 : sun, 200%

You would like to know how much hours of every rate a person totalizes per given day or week, moth etc.

Correct?

If yes, I would solve it like this:

Assuming you have:

- 1 field called total hours that returns the total hours worked on a given day

- one called day wich is returning the day number

- you're calculating on a per day basis.

rate 1 = total hours if not greater then 8 and weekday not greater than 5

rate 2 = if total hours is bigger then 8 and weekday not greater than 5, total hours - 8

rate 3 = if weekday = 6 ; total hours

rate 4 = if weekday = 7 ; total hours

Use the if() or case() functions.
If you don't have the fields like stated above, you can use variables with the let() function.

Got it?

I can't tell if it's the best or easiest way but it's probably how i would do it.

• 2. Re: Hours Multiplied by pay rate

Hi Jonas Gysin,

Would the calculation be

if total hours > 8

if total hours > 8 < 5 = total hours - 8

Is this right?

also should rate 3 and 4 be

if weekend = 6;total hours??

Can you right the calculation out so I know I'm not being stupid!! haha

1 of 1 people found this helpful
• 3. Re: Hours Multiplied by pay rate

Hi Chris,

Come on, you'll never learn if other people do your homework.

I'll give you the rate 3:

If ( day = 6 ; total_hours * 1.5 )

You may want to check ou the filemaker help (FileMaker Pro 15 Help)

logical functions : FileMaker Pro 15 Help

Kindly,

Jonas

1 of 1 people found this helpful
• 4. Re: Hours Multiplied by pay rate

Haha thanks very much Jonas I'm useless at If commands #stilllearning

• 5. Re: Hours Multiplied by pay rate

You're welcome!

Give it a try, read the few pages of the help file I linked, everything is there.

You can test your code directly in FM. Worst case : It doesn't work.

If you're stuck, post back here. If you manage it, you won't be useless at it anymore!

• 6. Re: Hours Multiplied by pay rate

I tried this and it didn't work.

• 7. Re: Hours Multiplied by pay rate

Ok well can you post the commands you wrote? We'll see from there.