How to enter fractions of an hour in time sheets in Small Business Accounting, in Accounting Professional, and in Accounting Express

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

INTRODUCTION
This article describes how to enter fractions of an hour in time sheets in Microsoft Office Small Business Accounting, in Microsoft Office Accounting Professional, and in Microsoft Office Accounting Express.
MORE INFORMATION
When you enter the amount of hours that an employee has worked in a time sheet, you must enter the minutes as a fraction of an hour. For example, if an employee worked one hour and 20 minutes, you would type 1.333 in the Duration (Hours) field. The following chart shows how minutes are converted to a fraction of an hour by dividing the number of minutes by 60.
MinutesFraction of an hour
00.000
10.017
20.033
30.050
40.067
50.083
60.100
70.117
80.133
90.150
100.167
110.183
120.200
130.217
140.233
150.250
160.267
170.283
180.300
190.317
200.333
210.350
220.367
230.383
240.400
250.417
260.433
270.450
280.467
290.483
300.500
310.517
320.533
330.550
340.567
350.583
360.600
370.617
380.633
390.650
400.667
410.683
420.700
430.717
440.733
450.750
460.767
470.783
480.800
490.817
500.833
510.850
520.867
530.883
540.900
550.917
560.933
570.950
580.967
590.983
601.000
MOA
Properties

Article ID: 905278 - Last Review: 09/10/2011 19:05:00 - Revision: 2.0

Microsoft Office Accounting Professional 2008, Microsoft Office Accounting Professional 2007, Microsoft Office Accounting Express 2008, Microsoft Office Accounting Express 2007, Microsoft Office Small Business Management Edition 2006

  • kbmbsmigrate kbhowto KB905278
Feedback