Time calculation

[shorty]

I have a checkin field (time) and checkout field (time)checkin field (time) and Checkout field. A subtime field (calc), this calc the time for the first checkin and checkout, then a subtime2 field (calc) this calculates the time for the 2nd checkin and checkout. Then a Tot Mon Time field (time)Subtime2-Subtime to get the final for the day. Now I do this for each day and then I have a total weekly period calc (time) that adds each day. My problem is that I want to be able to take the hourly rate x total period hours to get the gross pay. I keep just getting large numbers, I know it must have something to do with the fields being time fields but how do I convert those for calculating the gross pay. Any help would be appreciated.

[RussBaker]

Time in FMP is stored in seconds so when you multiply a time field by an "hourly" rate, it applies that rate per second, not per hour - thats the cause of your large numbers.

SO - You need to get the hours component of the time field. Then you need to decide what you're going to do about paying people for partial hours. This cal will do this (to the minute)

Pay = Hourly Rate * (Hour (total_time) + Minute (total_time)/60)

where total_time is the weekly figure you refer to.

OR - you could convert the hourly pay rate to a "seconds" rate and multiply that by the total_time field so that:

Pay = total_time * hourly rate / 3600

Russ Baker

Canberra, Australia

[shorty]

Thank you very much. The calculation headed me in the correct way. I now have been told that they want to change to calculating the partial minutes on a 7 minute basis, will have to incorporate this to the total time first i expect.

Thank you again for your help

Shorty

[RussBaker]

Try:

Pay = Hourly_Rate * (Hour (total_time) + int(Minute (total_time)/7)/9)

You might want to consider making your 7 minute blocks as a field itself so that different consultants in the company could have different time blocks for their rates - gives you more flexibility. The "/9" bit is because there are a bit over 8 seven minute blocks in an hour.

Russ Baker

Canberra, Australia

[Fitch]

One way is with a Case calculation:

MyHoursTotal =

MyHours +

Case(MyMinutes<8 , 0,

MyMinutes<23 , .25,

MyMinutes<38 , .5,

MyMinutes<53 , .75,

1)

[RussBaker]

Concur...

Russ

[shorty]

Russ

Thank you for the new calculation. The company wants to use this type of table for determining the partial minutes.

0-7 minutes=Round down

8-22 minutes=.25

23-37 minutes=.50

38-52 minutes=.75

53-59 minutes=Round up to next hour

Not sure where to go with this type of table.

Any clues?

[shorty]

Thank you for all the help.

I have learned a very valuable lesson. Make sure the owners tell you up front they have children that can make decisions on what goes into the program.

Now I have to add a section on figuring the federal withholding, state withholding, (using the tax percentage method), also having the gross pay to be for hourly, hourly + commission, salary + commission, salary alone

Puts a whole new meaning to the term we just want a time clock program.

Thanks again I will probably be back.

shorty