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):
English (United States) MM/DD/YYYY Format
And here’s what it looks like with the Windows 10 Region Format set to English (Australia):
English (Australia) DD/MM/YYYY Format
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 appears.
Choosing the Date Format Region (Windows 10)
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.
Change the Time Display Format on the 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).
Hours and Minutes
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 right.
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 is.
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.
Simple Overtime – Payroll Settings
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).
Simple Overtime – Overtime Settings
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 done!
The recent move of this web site to a secure server requires all users of the Email Alert system to update their Time Clock MTS Web Extensions installation to the latest version. The upgrade installer can be downloaded here:
Download Web Extensions Upgrade Installer
You’ll have to download and install the update on any computer that is using email alerts.