Hi all,

I'm trying to make a "basic" database that will calculate my daily and weekly hours, and also do a calculation that factors in all income tax percentages. The system is based on a bi-weekly paycheck, so my db features a 14-row portal that allows me to visually see all two weeks (should I work 14 days straight) without having to scroll down.

I have attached the database to this post with hopes that someone can help me with the daily hours calculations (I work by the hour). I have fields for time clocked in, time clocked out for break, time clocked in from break, and time clocked out. The portal row even features a daily hours field which is what is added up to created my estimated pay. I have never worked with calculating time before, and I can't begin to think about how it would be calculated... especially since some days I work until after 12am, which is a different day than when I clocked in. This is all I need help with. Once the time calculations are complete, I will be able to finish the database on my own.

Any input and/or help would be appreciated. I'm working for a start-up business and I want to make sure my paychecks aren't short.

Many many thanks!

Work_Hours_and_Pay.fp7.zip

Payroll is the most difficult and important aspect of any business. The state, local and government rules change constantly and you will have to deal with payroll tax and withholding.

It is one thing to use a database to track employee hours; that's fine ... it is another to compute proper salary according to ever-changing Labor Laws and withhold proper taxes, including paying them when required. The rules change constantly.

I would strongly suggest that you pass this piece on to a payroll company (there are many good ones which accept data on line) and it is their job to stay up with the regulations and deal with disputes. They are very inexpensive and well worth saving the Employer the time, effort and potential issues with such a process. :wink2:

Payroll is the most difficult and important aspect of any business. The state, local and government rules change constantly and you will have to deal with payroll tax and withholding.

It is one thing to use a database to track employee hours; that's fine ... it is another to compute proper salary according to ever-changing Labor Laws and withhold proper taxes, including paying them when required. The rules change constantly.

I would strongly suggest that you pass this piece on to a payroll company (there are many good ones which accept data on line) and it is their job to stay up with the regulations and deal with disputes. They are very inexpensive and well worth saving the Employer the time, effort and potential issues with such a process.

thank you. i understand this, but i would still like to be able to compute my daily hours and at least come up with an estimate pay for my pay check. as it's only a part time job this data isn't essential, but i would like to at least have a general idea of my total hours worked... the final figure of my paycheck doesn't need to be down to the last cent.

thanks again.

some days I work until after 12am, which is a different day than when I clocked in.

Assuming you NEVER work more than 24 hours, you can use a calculation (result is Time) =

out - in - break out + break in + 86400 * ( in > out )

to calculate the total work time.

gracias senor. would the out, in, break in, break out fields be numbers or time? would the total hours of the day be a number or time field?

* edit = i see the result is time.

Edited September 1, 201015 yr by Guest

Everything is assumed to be of type Time. To convert from Time to Number (of hours), divide by 3600.

Everything is assumed to be of type Time. To convert from Time to Number (of hours), divide by 3600.

in my "weeks total" field, how do i add the daily hours? my 'daily hours' field is in a separate table to the 'weeks total' field. the only relation between the two tables is the 'week id'.

thanks again. you've been a big help comment!

Here's one way. Of course, you can do the conversion to hours at any point, not just at the end like I did.

Work_Hours_and_Pay.zip

perfect. you've answered all of my questions. thank you!

: