Time Clock MTS – Shift and Overtime Questions

From time to time I get a great email from someone and I like to publish the email (along with my response) on this blog. Here’s one I got today that is mainly related to shifts and overtime.

I’ve been using the trial and have a few questions mostly around shifts and overtime.

1) Can an employee be assigned more than one shift?

No, Time Clock MTS employees can only be assigned to one shift.

2) In the setup of different shifts, a restricted first clock-in can be set (but no logout?) When the end of the shift time is reached and the user did not clock out, what happens? Is the users automatically clocked out? Does this system keep track and count this as overtime? When does OT start? Can a user on a shift not start early and have it count towards overtime?

Time Clock MTS can only restrict clock in by shift. There is no restriction on when employees clock out. Furthermore, employees are not automatically clocked out. In fact, there is no automatic clocking in or out anywhere in Time Clock MTS.

All hours worked can be used to track overtime. OT starts as per what you’ve setup on the Overtime Settings screen. Time in excess of shift length cannot be used against the next shift to prevent overtime accruing.

3) When overtime is applied, (after 40 hours weekly), is this weekly OT rate equal to the rate of the daily OT Rate 1? If not what is it?

Yes. Weekly OT is always paid at OT Rate 1 The OT rates are set on each employee’s payroll information screen.

4) What happens if an employee, that’s not allowed overtime, clocks-out far past the end of their shift? Did their shift end automatically? If not, are they paid for those hours at the regular rate or not paid at all even though they clocked late?

Time Clock MTS will continue to accrue hours for an employee even if they clock out past the end of their shift. This is the case whether you have overtime enabled for that employee or not. The only way you can limit the number of hours used for wage calculations is to set that employee to be salaried (on the Payroll Information screen). That way the employee would get paid for the same number of hours regardless of how many hours they are actually clocked in.

5) What happens if an employee, that is allowed overtime, clocks out after his shift ended? Is he automatically clocked out or is he automatically on overtime? How would the system know to treat it as overtime?

The hours are recorded as normal against the weekly overtime limit. Obviously the hours will only go to overtime if the employee is already over the weekly overtime limit. Again, they will not be automatically clocked out because there’s no automatic punching in or out in Time Clock MTS.

6) Is there any way to restrict the clock out time of a shift end? Does it not matter because the employee is automatically clocked-out at shift end?

Right now there’s no way of restricting clock out time in Time Clock MTS.

7) How could we setup a situation where, for example, there’s one [alternately] employee that gets assigned a task to do during a different shifts (on the weekend)

Right now each employee can only be assigned to a single shift. We’re contemplating the idea of having a full schedule in Time Clock MTS at some time in the future but it’s not one of our immediate priorities.

Ultimately, the most desirable situation right now to know is, is there a way that we could configure the system to limit when the users clock-in in the morning and also when they clock-in after lunch? Even if it meant we would have to setup two shifts per user.

You can only restrict the time of the first clock in of the day.

Auto Body Time Clock System Review

Matt Petrella, of Petrellas Auto Body in Cortland, New York took the time to send through a great review of our Time Clock Software, Time Clock MTS today. You can find it and many other kind words from our users on the timeclock user review page.

Clearly, if you’re looking for a useful (and cost effective) timeclock system for your auto body or crash repair business then Time Clock MTS is what you should be using. Why not download the free 30 day trial today?

Exporting to Proliant Payroll from Time Clock MTS

A user of Time Clock MTS wanted to export their time clock data to Proliant Payroll Service. Proliant forwarded their import file requirements to me and it turns out that Time Clock MTS can export directly to Proliant using the built time clock export file format creator.

Proliant Time Clock Export Format 1

The first format Proliant can import is an aggregate format that is simply a line per rate type per employee. For example, Employee badge 146 works 40 hours of regular time and 10 hours of overtime during the week. The company’s code for regular earnings is R1 and the code for overtime is O1. The resulting record in the time clock output file would be:

“146”,”E”,”R1″,40.0
“146”,”E”,”O1″,10.0

Here’s how you’d setup an export format to produce this data:

Proliant Data Export Format 1

Proliant Data Export Format 1

Note that we’ve set the format type to AGGREGATE and the “E” field is a hard coded field required by Proliant.

Proliant Time Clock Export Format 1

The second format Proliant can accept is line by line listing of all time punches across a time period including the punch dates and times. For example, an employee with badge ID of 51 works the following hours in a week:

  1. 8/1/2013, In : 9:30AM, Out: 5:30PM
  2. 8/2/2013, In : 9:00AM, Out: 5:00PM
  3. 8/3/2013, In : 8:45AM, Out: 10:45AM
  4. 8/3/2013, In : 10:45AM, Out: 4:45PM
  5. 8/4/2013, In : 9:00AM, Out: 5:00PM
  6. 8/5/2013, In : 8:30AM, Out: 4:30PM

A resultant data file for this would be:

“51”,”E”,”Reg”,8.0,,,,,,,,,,,”8/1/2013 9:30:00″,”8/1/2013 17:30:00″
“51”,”E”,”Reg”,8.0,,,,,,,,,,,”8/2/2013 9:00:00″,”8/2/2013 17:00:00″
“51”,”E”,”Reg”,2.0,,,,,,,,,,,8/3/2013 8:45:00″,”8/3/2013 10:45:00″
“51”,”E”,”Reg”,6.0,,,,,,,,,,,”8/3/2013 10:45:00″,”8/3/2013 16:45:00″
“51”,”E”,”Reg”,8.0,,,,,,,,,,,”8/4/2013 9:00:00″,”8/4/2013 17:00:00″
“51”,”E”,”Reg”,8.0,,,,,,,,,,,”8/5/2013 8:30:00″,”8/5/201316:30:00″

Here’s how you’d setup an export format to produce this data:

Proliant Data Export Format 2

Proliant Data Export Format 2

Note that we’ve set the format type to EVENT and the “E” field is a hard coded field required by Proliant.

What is Pyramiding Overtime

Overtime pyramiding or overtime doubling is the (often mistaken) practice of counting the same hours against two different overtime limits. The most common example of overtime pyramiding is using hours that have been counted against daily overtime to calculate a weekly overtime limit. This is especially common because daily overtime is usually a state level requirement and weekly overtime is a federal requirement. If you’re having trouble understanding pyramiding in this context it is more easily explained through the use of an example. Let’s consider an employee that works five 10 hour days in a single week, has a daily overtime limit of 8 hours and a weekly overtime limit of 40 hours.

Day Hours Worked Overtime Pyramiding
(Normal Hours / Daily OT Hours / Weekly OT Hours)
Overtime No Pyramiding
(Normal Hours / Daily OT Hours / Weekly OT Hours)
Monday 10 8/2/0 8/2/0
Tuesday 10 8/2/0 8/2/0
Wednesday 10 8/2/0 8/2/0
Thursday 10 8/2/0 8/2/0
Friday 10 0/0/10 8/2/0
Total 50 32/8/10 40/10/0

So we can see in this example that if we pyramid overtime the employee is due to be paid 32 normal hours, 8 daily overtime hours, and 10 weekly overtime hours. If we do not pyramid overtime hours then the employee is due 40 normal hours and 10 daily overtime hours.

Is Pyramiding Overtime the Correct Practice?

In almost every case pyramiding overtime is NOT the correct way of calculating overtime. Of course this can vary by negotiated contract but in my experience employers are generally never going to sign an employment contract that allows for overtime pyramiding. It’s worth looking at some examples of labor policies where the practice of overtime pyramiding is specifically singled out as being incorrect.

A Memorandum from the Californian Department of Industrial Relations from 1999 – Division of Labor Standards Enforcement –

“The statute also provides that “nothing in this section requires an employer to combine more than one rate of overtime compensation in order to calculate the amount to be paid to an employee for any hour of overtime work.” This is consistent with DLSE’s enforcement of the pre-1998 wage orders. It simply means that there is no “pyramiding” of separate forms of overtime pay for the same hours worked. Once an hour is counted as an overtime hour under some form of overtime, it cannot be counted as an hour worked for the purpose of another form of overtime. When an employee works ten hours in one day, the two daily overtime hours cannot also be counted as hours worked for the purpose of weekly overtime.”

A Memorandum from the Californian Department of Industrial Relations from 2000. This is an interesting memorandum because it addresses EXACTLY the same example I gave above with an employee having worked five 10 hour days in a work week. Here’s the relevant ruling from the DIR:

“On each work day, the employee is entitled to two hours of daily overtime pay, and these daily overtime hours would not be counted for the purpose of any other overtime payment, such as weekly overtime hours”

And here’s an employer specific example, a direct extract from the overtime policy of the University of Michigan:

“Pyramiding : Overtime will not be pyramided, compounded, or paid twice for the same time worked”

Of course your state or country may have different regulations and you should consult with a lawyer as to what your local requirements are.

Using a Time Clock System to Calculate Overtime Easily

The best way of dealing with complex overtime calculations is to automate them. This way you only need to configure your overtime rules once and they are applied correctly (and impartially) from that time forward. A easy pc timeclock like Time Clock MTS is an ideal solution for both the collection of your employee time clock data AND automatic overtime calculations. In fact, Time Clock MTS includes overtime settings specifically designed to STOP overtime pyramiding. We include an overtime calculation scheme called “Daily and Weekly Overtime (No Double Up)”. Below you can see how Time Clock MTS correctly calculates overtime for the example I gave at the beginning of this article.

Correct Overtime Calculations in Time Clock MTS (no Pyramiding)

Correct Overtime Calculations in Time Clock MTS (no Pyramiding)

What Other Overtime Can Time Clock MTS Calculate?

Time Clock MTS includes (as you’d expect) limits for both daily and weekly overtime. It also includes a seventh day overtime setting and limit allowing you to pay employees overtime on the seventh day worked in a week. Hours prior to the seventh day limit will be paid at Overtime Rate 1 and hours after the limit will be paid at Overtime Rate 2. This allows you to make Time Clock MTS compliant with California Seventh Day Overtime Requirements.

If required you can flag a weekday as always being paid as overtime. Also, the administrator can fine tune overtime payments by individually marking time punches to be paid as overtime, or specifically excluding some times from overtime payments.

What About Excluding Sick Time, Holidays, and Vacation from Overtime Payments?

The Federal Fair Labor Standards Act (FLSA) says that overtime limits are to be calculated from hours worked. It then goes on to specifically exclude holidays, sick time, or vacation from being hours worked and thus those hours do not have to be included in the total hours worked for overtime purposes. However, some employers policies (such as Dartmouth University) DO consider those hours as hours worked for overtime. Time Clock MTS has the flexibility to allow you to work either way. It has settings to allow paid holidays to affect overtime and a similar setting to allow sick / vacation time to affect overtime. See the Time Clock MTS Overtime Settings page for more help with these settings.

Get Your Overtime Calculations Under Control with Time Clock MTS

If you’re not using a time clock program to record your employee time and attendance and automatically calculate your employee overtime pay then you’re wasting your time and money. Time Clock MTS costs just $99 (US) to install on a single computer and track up to 500 employees. We’re confident you’ll make back the purchase price of Time Clock MTS in just a few weeks of saved time and reduced payroll costs. In fact here’s what one of our happy users had to say:


Time Clock MTS has a 100% functional 30 day free trial available so why not get our software into your business today and stop worrying about overtime pyramiding and overtime calculations?

Employee Time Management Systems and Tardiness

Above is a statement from Kristina Harford who is the operations manager at Infectious Disease Associates of Tampa Bay. She’s talking about Time Clock MTS, which her company has been using as an employee time management system for several years. There’s no doubt that controlling tardiness of employees is a key role of any department supervisor or payroll department and a good staff clock in system should allow those same things to be recorded and monitored easily.

What is Tardiness and is it a Problem?

Tardiness is the delay between an employee starting work and when they should have started work. It’s also lateness during the work day, such as being late back from lunch, arriving at meetings late, and being late to customer appointments. In this article I’ll just be considering tardiness as “being late to work”. Is tardiness a problem? The answer is yes. In 2011 Careerbuilder suggested that tardiness was an important issue in the US labor market with 16% of employees late to work at least once per week and more than a quarter of employees late to work at least once a month. HR Magazine stated in 2005 that tardiness was costing the US economy more than $3 billion a year.

More recently, in the much smaller British economy it has been suggested that employees being late to work is costing the British economy more than $14 billion per year and that the average amount of time staff are late to work is nearly 4 minutes per day. Here’s what one business owner in that article said about employees being tardy:

“Time is money and when it comes to making business journeys, punctuality and speed are crucial.”

So What Does Tardiness Actually Cost?

It’s easy to assume that tardiness cost is calculated by multiplying the employee’s hourly rate by the amount that they are late. But, some human resources experts suggest that the real monetary cost of an employee being late is 2-3 times their hourly rate. This approach considers the cost of the employee’s time, the cost of the office/factory/store space that is going unused while the employee is not working and the cost of employee overheads and benefits, I’ll take this one step further and suggest that the opportunity cost of foregone profit should also be considered when an employee is continually late.

So how much does an employee being late to work actually cost? In the interests of being conservative I’ll just go ahead an assume that the real cost of tardiness is the hourly rate of the employee multiplied by the time the employee is late. Given that the median wage in the US is about $13 per hour an employee that is 15 minutes late once a week is costing you $169 per year. A great example in non monetary terms is that if an employee is late to work just 10 minutes each day then you, are in effect, giving them an extra week of paid vacation each year. Whatever way you look at it, late employees cost money and it cannot be ignored.

Tardiness Costs More Than Money

There’s a financial aspect to employee tardiness that cannot be ignored. But there are other, less easy to measure costs that tardiness has on the business. What these costs are is worthy of an article by itself but here’s a few impacts of late employees that you might not have considered:

  • Generally employees do not want to be late to work. When an employee arrives late to work they are often flustered and upset and may take quite a while to settle into their daily work.
  • Less time at work leaves the employee with less time to complete their allotted tasks. It’s likely that their quality of work will suffer.
  • Tardiness can be a sign of underlying employee morale problems. If tardiness is being ignored then you could be ignoring deeper problems in your business.
  • Other (on-time) employees can be upset by employees who are continually late to work without that behavior being controlled.
  • Your customers can suffer. If employees are late opening up a shop or store then clearly that is going to cost you money. If your employee is late for customer meetings then that’s going to impact on the image that your business has in the marketplace.

Identify Lateness Trends Early

It’s imperative to identify lateness trends early. An employee who suddenly starts being tardy to work can be an employee who is suddenly suffering family or personal stress. Early identification can mean a quick discussion with the employee and either a solution to the lateness being found or the employer being flexible for an amount of time while the employee resolves their personal issues. Identification of a long term habit of lateness can point to underlying causal problems for an employee, perhaps transport problems, perhaps simple problems with time management, or perhaps dissatisfaction with their job. Whatever the case identifying the trend and then addressing the issue with the employee can potentially be far more effective than trying to enforce a no-questions-asked start time for work policy.

How Employee Time Management Systems can help Manage Employee Tardiness

The late for shift report displays all employees that have arrived for work after their designated shift start times.

The late for shift report displays all employees that have arrived for work after their designated shift start times.

A great employee time management system like Time Clock MTS will help you monitor employee tardiness as a normal part of your payroll duties. The system will allow your employees to clock in and out with a minimum of fuss and it should then produce easy to understand reports showing exactly when your employees arrived at work. Ideally there’d be some dedicated reports designed specifically to help identify employees who are late for work (such as the late for shift report in Time Clock MTS, see image above). The timeclock software should also provide a quick visual method of identifying who is or isn’t at work at any point in time.

Above you can see what Angie Andrade-Morioka, the directory of staffing and facilities at the University of Hawaii at Hilo had to say about how they are using Time Clock MTS to track tardiness. Remember, an employee who is late to work just once per week can be costing you up to $200 per year. Time Clock MTS has a fully functional 30 day trial available and costs just $99 (US) for the Stand Alone Version. If it can help you prevent just one employee tardy per week then it’ll pay for itself 2-3 times over in just a year. Why not give it a try!

What is the Time Clock MTS Network Edition

Time Clock MTS Network Edition

The Time Clock MTS Network Edition allows you to track the time and attendance data of up to 500 employees on 20 different time clock computers. The Time Clock MTS Network Edition costs $199 (US). It’s worth taking some time to look at what you get when you do purchase the Network Edition.

How Many Computers Can You Install the Software On?

You can install the Time Clock MTS Network Edition on 21 computers. 21?! Seems like an odd number but it’s quite easy to understand. The Time Clock MTS Network Edition allows you to use Time Clock MTS Administrator Software on one computer and the Time Clock MTS Client Software on up 20 computers. Basically this gives you one time clock manager computer and up to 20 computers that your employees can clock in and out of.

If you’re wondering how you should setup the software to share your data then you should probably read this guide. We always recommend that you move your time clock database to your local network server where it can easily be shared and is backed up. Remember that bad things can happen if you do not backup your time clock data.

How Many Employees Can You Track?

The Network Edition of Time Clock MTS can track from 1 to 500 employees. There’s no limit to how many times those employees can clock in and out every day.

How Much Does it Cost? Are There Monthly or Annual Fees?

Right now the network edition of Time Clock MTS costs $199 (US). Your purchase entitled you one year of technical support via email and access to software updates. Support after the first year is 25% of your initial purchase but your software will keep working whether you renew support or not.

Do I Get Access to All Time Clock MTS Features?

When you purchase the Time Clock MTS Network Edition you get full access to every feature the software includes. That means you get full access to fingerprint security, job tracking, time off requests, tip tracking, sick and vacation accruals, overtime calculations, and being able to generate dozens of payroll reports.

The only restriction is that you can install the Time Clock MTS Client software on 20 computers at most.

The Time Clock MTS Client Software

The Time Clock MTS Client Software

Do I Get Technical Support?

Yes. As with all Time Clock MTS purchases you’ll get one year of technical support via email and access to all of our on-line support systems and resources. To continue to receive email technical support after the first year you can renew for a further 12 months which will cost $50 (US) for the Network Version. Note that the support renewal costs for the Stand Alone Version and the Network PLUS Version are different.

Do I Get Software Upgrades?

Again, as with all Time Clock MTS purchases you’ll get access to one year of software upgrades. If you want to continue receiving access to software updates then you’re going to need to renew your technical support contract as discussed in the point above.

I am an Existing Time Clock MTS User. Can I Upgrade to the Time Clock MTS Network Edition?

Absolutely. If you’re a current Time Clock MTS user, perhaps using the Stand Alone Edition or one of the older versions of the software then you can easily upgrade to the Network Edition. Just visit our Upgrade to the Time Clock MTS Network Edition page where you can enter your registration codes and you’ll be able to purchase an upgrade at a discounted price.