Jump to content

Overtime Problem


Lucky
 Share

This topic is 5699 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi

I am trying to change the Time Card solution supplied with Filemaker 8.5 to calculate overtime worked in the morning.

We officially start at 8:00 AM. That's when we get paid from.

If we are asked to do overtime ( Come in early ) we must clock-in before 7:34am before the overtime rate starts.

ie:

Field "Start Time" = 7:00 am........Field "Morning Overtime" = 1.00

Field "Start Time" = 6:30 am........Field "Morning Overtime" = 1.50

Field "Start Time" = 7:35 am........Field "Morning Overtime" = 0

Can anyone help me with the calculation?

Edited by Guest
Link to comment
Share on other sites

So if they clock in at 7:32, is it considered overtime of 28 minutes of 2 minutes? At what increment does it count as overtime? Every 15 minutes? half hour? or is it to the minute?

Link to comment
Share on other sites

Hi

What we have is a manual clocking in machine that punches a time card.

We then enter the details into the Filemaker Solution. So if we had clocked in at 7:32am we would be paid from 7:30am ( .5 Hr )

We are allowed 4 mins past each quarter of an hour.

6.04

6.19

6.34

6.49

7.04

7.19

7.34

8.04

But as we manually enter the times into FM we would round them up to the nearest 15 mins. Apart from 7:34am because they my company asumes by the time you have settled in , Made a cup of tea and had a chat it would be nearly 8:00 am anyway.

Yes I know there tight arses.

Link to comment
Share on other sites

I tried to use this for a personal project, but discovered it was built using repeating fields, and would have been too hard to convert to a Relational one.

I entered some test data and discovered that it was doing the rounding too, and not computing it according to the California Overtime rules.

8 hours, 10 hours, and 12 hours in a Day, More than 40 hours in week, meal periods, break periods, more than 5 days in a week, etc.

I believe you can change the round 15 minutes by changing the calculation in the data file.

HTH

Lee

Link to comment
Share on other sites

I took a quick peek at your file.

Here is an example of what I meant in my post that wouldn't work in this file..

I had a lot of days where Hours worked were more than 8 hours in a day are overtime. However, if they work more than 10 hours the OT Factor had to change for the hours over 10 hours (i.e Double)

Another Break field is require when a person works more than a net 8 hours (after lunch break) because a lunch break of 30 minutes is required. I suppose that you could add the two together in the one provided, but I don't consider that very good for documenting for the State Reviews.

Another problem arises because of the number of days worked in any one Work Week. (i.e. in my case Sunday through Saturday). If the person work Sunday, that was day one, and if they worked the rest of the week, then Hours worked on Friday would be Regular OT, and if they worked Sat, the time would be Double.

There were so many varibles in persons Times, I ended up using a few flags fields, and a couple of Scripts to get what I needed.

I would be happy to share some actual work times that I had to overcome, but the project is complete.

Link to comment
Share on other sites

I dont understand why you would need to do this. Plus if 7.15 is supposed to be a number wouldn't it actually be 7.25 if its representing 7 hours and 15 minutes? I am not following sorry.

Link to comment
Share on other sites

If I understand the question correctly, MorningOvertime (result is Number) =

(28800 - StartTime) /3600

or:

8 - StartTime /3600

This doesn't include rounding to nearest (?). Also, the official starting time of 8:00 AM probably shouldn't be hard-coded into the calc (in case it ever changes), but looked-up into a field.

Edited by Guest
Link to comment
Share on other sites

Hi

Thanks everyone for the help.

I think I'm nearly there!, Probably created a lot more fields than I needed to.

I have attached the file showing what I have done.

I have just a small problem of 2 fields that have 7 repetions each and when a new record is created the official start and finish times need to appear in them automatically to help with my calculations. They only seem to appear in the repetition 1.

Peter

Time_Cards.zip

Link to comment
Share on other sites

This topic is 5699 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.