# Calculating hours worked in a given week

Question asked by CarlWeston on Dec 21, 2012
Latest reply on Dec 22, 2012 by CarlWeston

### Title

Calculating hours worked in a given week

### Post

I have searched the forums but I can't seem to get the answer I'm looking for.

I am a freelance graphic designer and get paid by the hour. I have created my own Timesheet.

I am trying to get the total income earned for a specific week.

For instance, I have 1 record per day showing the current date, time start, time finish, hours worked, rate, income earned, tax and total hours worked for the day.
If I worked for 5 days this week, how do I calculate what the total earnings are for those 5 days?

For example;
17 Dec = 9hrs
18 Dec = 8.25hrs
19 Dec = 9hrs
20 Dec = 8.5hrs
21 Dec = 9.5hrs
Total Hours worked for the week = 44.25, multiply this by my rate and I get the total income earned for that week (+ tax).

Obviously this is really simple with a calculator, but for the life of me I can't seem to get my head around how to do this automatically in Filemaker.

Any help or examples of calculations would be appreciated.

Cheers,
Carl.