Timesheet calculations

Timesheet calculations

When employees punch in and out in Kennel Connection, it records their punches and calculates the number of hours/minutes they work.  You can run a report that gives you the total time under Reports, Revenue, Time Sheet.


You can opt to run the time sheet in hundredths (decimals instead of minutes) or in tenths (minutes).  To set your option, go to File, System Options, Global tab.


The option is "Show time sheet hours in hundredths".



Timesheet calculations



Option set to NOT show time sheet in hundredths.


Below is an example.  The employee worked 6 hours, 25 mins; 6 hours, 14 minutes; 2 hours, 45 mins, and so on.  KC calculates the total time worked as 41 hours, 6 minutes.


Timesheet calculations



In order to get the total time, you must first add up the hours.


6+6+2+3+6+4+4+6 = 37


Then you add up the minutes.


25+14+45+51+44+1+46+20 = 246 minutes.


To find out how many hours that is divide 246 by 60 = 4.1.


Add 4 hours to 37 = 41 hours.


The remainder of .1 is not minutes.  It is a percentage of minutes.


To find out how many minutes .1 is, multiply .1 by 60 = 6 minutes.


The total is 41 hours, 6 minutes.



Option set to show time sheet in hundredths


Below is the same time sheet as above, but calculated in hundredths (showing as a decimal instead of minutes).  Add up the times and KC calculates it to 41.10.



Timesheet calculations



For example, 7:53am to 2:18pm is 6 hours, 25 mins.  To calculate the minutes in hundredths, divide 25 by 0.6 to get 41.666.  KC will round, so it shows as 6.42.


7:58am to 11:59am is 4 hours, 1 min.  To calculate the minutes in hundredths, divide 1 by 0.6 to get 1.666.  KC will round, so it shows as 4.02.


To calculate 41.10 into minutes, multiply 10 by 0.6 = 6 mins for a total of 41 hours, 6 mins as shown in the top time sheet.


    • Related Articles

    • Timesheet does not print

      If you are trying to print Reports, Revenue, Timesheet and Kennel Connection either freezes or spins, that means there is a punch that is out of order with the in time after the out time.  KC is not able to calculate it so it can't print the report ...
    • Calculating wages with the timesheet

      The time sheet report can calculate hourly wages for your employees.  NOTE: You MUST be an administrator for this "show wages" option to be available. This is not available to anyone who is not a KC administrator.  To set someone as a KC admin, open ...
    • Daycare type revenue

      Reports, Revenue, Daycare type revenue prints the number of appointments for the day, separated by Daycare type/room, along with the total rates of the appointments.
    • Package revenue

      If you sell multiple types of packages, such as different boarding, daycare, grooming or other packages, and need to know which clients/pets bought a specific one, set up its own category so you can run the sales report. Click on File, Inventory, ...
    • Adding employees and setting Access Rights

      The employee setup in Kennel Connections allows you to: Set up security levels Designate employees as bathers, groomers, trainers, and so on. Give each employee individualize access rights. Set schedules Make employees commission-able Please note: ...
    After-Hours Emergency Support
    For use ONLY outside of business hours. (Mon-Fri, 8am to 7pm ET). 

    To avoid any delay, be sure to search this knowledgebase for your issue prior to submitting a ticket. Most answers can be found here.

    If you're issue does NOT consist of one of the following, please email support@kennelconnection.com with your issue to create a ticket and someone will get back to you on the next business day. 

    - Kennel Connection Desktop - Will not open on any machine including server. 
    - KC-Cloud - Cannot login/spinning and you've verified you have Internet.
    - KC Online Reservations - Clients are getting an error upon login or cannot book ANY reservations.
    - Hello-Groom - Cannot login/spinning and you've verified you have Internet.
    - Credit Card Processing - Cannot take payments at all from any method.
    - PawLoyalty - Cannot login/spinning or extreme latency and you've verified you have Internet.

    *Utilizing the emergency support for non-emergencies will not receive a call back.
    *Users without a valid subscription will not receive a call back and will need to speak with a sales representative on the next business day.