Knowledgebase
How To Convert Minutes To Hundredths For Calculating Time
Posted by Charles Williams on November 25, 2009
Additions and subtractions for time done on a calculator without converting minutes to tenths or hundredths causes confusion when verifying or calculating employee hours. Without converting the minutes to hundredths, the caluclations can be off because an hour contains 60 minutes and regular calculations done on a calculator are displayed in units of 100.

For example, if an employee worked 9 hours, 32 minutes on one day and 8 hours, 56 minutes on another day, the totals will display on the 7000E or in PayClock as 9:32 and 8:56, if the settings were not adjusted to show totals in hundredths. If trying to add these times together on a calculator without converting the minutes to hundredths, the total would display as 17.88. This is incorrect.

9.53  The conversion of 9 hours, 32 minutes.
8.93  The conversion of 8 hours, 56 minutes.
18.46  The total hours after converting the time.

Similarly, with the 2000 and 4000 Series Timeclocks that print in standard minutes, if an employee clocks in at 7:56 and out at 15:35, if subtracting 7:56 from 15:35, the total would display as 7.79. This would be incorrect.

15.58  The time conversion of 15:35 OUT.
7.93  The time conversion of 7:56 IN.
7.65  The total daily hours after converting the time.

The Mechanical Time Recorders come with the Dial of Decimal Equivalents, which displays the conversion slightly different from how our software products round the time:

15.58  The time conversion of 15:35 OUT.
7.94  The time conversion of 7:56 IN according to the Dial.
7.64  The total daily hours after converting the time.

A Time Conversion Chart is provided here to help with the converting of the time from minutes to 10ths or 100ths prior to adding it on a calculator.

Min. 10ths 100ths Min. 10ths 100ths Min. 10ths 100ths
1 0.0 0.02 21 0.4 0.35 41 0.7 0.68
2 0.0 0.03 22 0.4 0.37 42 0.7 0.70
3 0.1 0.05 23 0.4 0.38 43 0.7 0.72
4 0.1 0.07 24 0.4 0.40 44 0.7 0.73
5 0.1 0.08 25 0.4 0.42 45 0.8 0.75
6 0.1 0.10 26 0.4 0.43 46 0.8 0.77
7 0.1 0.12 27 0.5 0.45 47 0.8 0.78
8 0.1 0.13 28 0.5 0.47 48 0.8 0.80
9 0.2 0.15 29 0.5 0.48 49 0.8 0.82
10 0.2 0.17 30 0.5 0.50 50 0.8 0.83
11 0.2 0.18 31 0.5 0.52 51 0.9 0.85
12 0.2 0.20 32 0.5 0.53 52 0.9 0.87
13 0.2 0.22 33 0.6 0.55 53 0.9 0.88
14 0.2 0.23 34 0.6 0.57 54 0.9 0.90
15 0.3 0.25 35 0.6 0.58 55 0.9 0.92
16 0.3 0.27 36 0.6 0.60 56 0.9 0.93
17 0.3 0.28 37 0.6 0.62 57 1.0 0.95
18 0.3 0.30 38 0.6 0.63 58 1.0 0.97
19 0.3 0.32 39 0.7 0.65 59 1.0 0.98
20 0.3 0.33 40 0.7 0.67 60 1.0 1.00

A Note About Converting to Hundredths:There has been confusion about the use of the 1/100 hours option on reports. The problem stems from the fact that if a column of time is added, it may be off .01 or .02 hrs when totaled. There is No Error: the problem is that 1/60 hr cannot be easily nor perfectly converted into 1/100 hr.


Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).

Copyright (c) 2014 Lathem. All rights reserved.