# Newbie needs help with a formula for tracking hours and pay

Question asked by Zapple on Feb 17, 2009
Latest reply on Feb 18, 2009 by raybaudi

### Title

Newbie needs help with a formula for tracking hours and pay

### Post

I am brand spanking new to File Maker and Databases. I am trying to make a database to keep track of my hours and pay. I am an hourly wage earner. I have many employers and need to keep track of the hours per job and production and a cumulative total of my working hours. The first problem I have is this. Each day i work I am guaranteed 8 hours of pay. After 8 hours my pay rate increases to 1.5X up to a total of 12 hours. After 12 hours my pay rate increases to 2x's up to a total of 16 hours. After 16 hours my pay rate is 2.5x. So if I work 14 hours, I will receive 8 hours at 1x my pay rate. (lets use \$10 as the rate). How can I input the number of hours and have them broken down into the different rates based on the hours worked. So in this example working 14 hours at \$10/hr. The first 8 hrs is at \$10/hr, the next 4 hours are at 1.5x my rate or \$15hr and 2hrs at 2x or \$20/hr totaling \$180 for the 14 hours of work, \$80+\$60+\$40.

Any help is greatly appreciated.