How can I automatically total the employee work hours downloaded from my BioTouch time clock?

To determine your clock’s firmware version, refer to this knowledgebase topic.

For BioTouch Clocks with firmware versions prior to version 3.9:

• Raw punches collected using the BioTouch time clock are downloaded to the PC and displayed in an Excel spreadsheet.
• The clock itself does not automatically calculate total hours worked. This operation must be performed in Excel. To assist with this task, we have created a free Excel macro available for download. Download the instruction sheet first to review the steps, then download the file.
  • Instruction sheet
  • Macro file (.XLS format)
• The macro was not designed to handle time calculation rules (i.e. rounding, overtime) or manage schedules, benefit hours, accruals, etc. If you require this additional functionality, please contact Sales at 1-800-334-7190 or 1-919-872-5800 to discuss purchasing Acroprint’s timeQplus Network Software. The timeQplus Network Software can import the raw punch data from the BioTouch and allow you much more power and flexibility to handle all your time and attendance reporting needs such as rounding, overtime, and shift and lunch rules.

For BioTouch Clocks with firmware versions 3.9 and higher:

• Raw punches collected using the BioTouch time clock are downloaded to the PC and displayed in an Excel spreadsheet.
• The clock itself does not automatically calculate total hours worked. This operation will be performed in Excel. You must first make sure the totaling feature has been properly turned on (min=60 min format or HR=100th minute format) and the macro has been added to the clock’s settings.
• Excel will not handle time calculation rules (i.e. rounding, overtime) or manage schedules, benefit hours, accruals, etc. If you require this additional functionality, please contact Sales at 1-800-334-7190 or 1-919-872-5800 to discuss purchasing Acroprint’s timeQplus Network Software. The timeQplus Network Software can import the raw punch data from the BioTouch and allow you much more power and flexibility to handle all your time and attendance reporting needs such as rounding, overtime, and shift and lunch rules.