Time Clock Software Blog

A Blog from the authors of Time Clock MTS, a cost effective time and attendance software solution

The Date Format on Report Configuration Screen

From time to time we get asked how to change the date format on the report configuration screen. In fact, you cannot change the format from within our software because the format used is retrieved from the Windows regional date format setting. However, you can certainly change the format, from say, MM/DD/YYYY to DD/MM/YYYY but you’d have to change the regional date format that Windows uses and then restart Time Clock MTS to pick up the new setting. For example here’s the relevant part of the Report Configuration screen with the Windows 10 Region Format set to English (United States): And here’s what it looks like with the Windows 10 Region Format set to English (Australia): Now, how you change your Windows regional date format is really beyond the scope of this article. But if you’re on Windows 10 type “region” into the taskbar search box and choose the Region & Language Settings option. Then choose the Additional date, time, & regional settings option which you’ll see part way down the screen. Finally on the Clock Language, and Region window choose the Change date, time, or number formats and choose your regional format from the window that then... read more

Choose Time Punches from Hours and Minutes or Decimal Hours

Time Clock MTS records all time punches accurate to the second. It can display elapsed times between time punches in either hours and minutes (1:30) or decimal hours (1.50). Hours and minutes are typically used for timesheets in most businesses. Decimal hours are usually used when time needs to be tracked, costed, and even charged out. Obviously it’s a lot easier to cost out 10.85 hours at $50 / hr than it is to cost out 10 hours and 51 minutes at $50 per hour. Changing how times are displayed in Time Clock MTS is controlled from the Tools->Options->Report Settings Screen. Choosing between the two time display formats is simply a matter of choosing an option from the Display Times as drop down. A Comparison of the Two Time Display Formats Below is a side-by-side comparison of the same time card displayed with hours and minutes (left) and decimal hours (right). Some examples to note are the first time punch, recorded as 7 hours and 30 minutes on the left and as 7.50 hours on the right, and the second punch recorded as 7 hours and 15 minutes on the left and 7.25 hours on the... read more

Update to Database Export Tool Posted

We’ve just posted a small update to our tool to export data to SQL Server or MySQL. The rather imaginatively named “Database Exporter” will now gracefully handle the case where NULL values have been inserted into numeric database columns. This can ONLY happen if you’ve added custom data columns to the Time Clock MTS database, as Time Clock MTS is well-mannered enough to make sure it actually inserts values into numeric columns rather than leaving them NULL or empty. The latest version of our Database Exporter tool can be downloaded from here. Note that this tool CAN ONLY BE RUN FROM A COMPUTER WITH TIME CLOCK MTS INSTALLED ON IT as it is dependent on libraries that are installed with our time clock software. Note also that it must be installed in the same folder that Time Clock MTS... read more

Setting up Simple 40 Hour Weekly Overtime

Here’s a question we got recently from a user: I’m wondering how to setup our overtime rules. Our overtime is calculated based off a Sunday to Saturday work week. Any hours worked over 40 should be paid at overtime rate. There’s two things to answer here, firstly, how to setup the work week, and second, how to setup the simple 40 hour weekly overtime. The first day of the work week can be configured from the Tools->Options->Payroll Settings screen, which is only accessible when you’re logged in as the time clock administrator. The Payroll Settings screen scan be seen below. To change the First Day of the Week choose an option from the First Day of Week dropdown. In this case we’re going to choose Sunday. This means that overtime calculations will start on Sunday of each week. Next we need to adjust the overtime settings to suit, overtime settings are available on the Tools->Options->Overtime Settings screen (see below). Setting up weekly overtime using this screen is quite simple. Make sure ALL boxes are unchecked except for the Pay Weekly Overtime box. Enter the Weekly Overtime Limit in the text box next to this checkbox, in this case 40 hours. The final step is to choose a Overtime Calculation method from the Overtime Calculation dropdown box. We’ll choose “Weekly Only” in this case. When you’re happy with settings click the Save button and you’re... read more

Exporting Time Clock MTS Data to SQL Server or MySQL

We’ve just made setting up Time Clock MTS to work with a SQL Server Database or a MySQL Database much more quicker and simpler. Our new Database Exporter tool (see the image below) can take all of your existing time clock data and send it straight to an empty SQL Server / SQL Express database or to an empty MySQL database. It makes setting up the Network PLUS Edition of Time Clock MTS a whole bunch easier, allowing your time clock to support up to 100 time clock stations and track up to 1000 employees! You can read more about the Network PLUS Edition of Time Clock MTS... read more