Overtime Problem

[Lucky]

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 February 13, 2007 by Guest

[mr_vodka]

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?

[Lucky]

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.

[Lee Smith]

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

[mr_vodka]

Possibly something like this?

Time_Cards_Mod.zip

[Lee Smith]

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.

[mr_vodka]

Yes you are right Lee, with these kind of things, it totally depends on the rules of business.

[Lucky]

Thanks for the help.

How would I go about converting a Time field into a number so I could subtrack it from a number. ie:

Start Time 7:15 am = ( 8:00 - 7.15 ) Overtime =.75

[mr_vodka]

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.

[comment]

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 February 20, 2007 by Guest

[Lucky]

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

[mr_vodka]

You do not need day 1 - day 7 fields. You can use one.

Time_Cards_3.zip

[Lucky]

Nice one.

Thanks again.