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

Work anywhere from any device with Microsoft 365

Upgrade to Microsoft 365 to work anywhere with the latest features and updates.

Upgrade now

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.

Minutes

Fraction of an hour

0

0.000

1

0.017

2

0.033

3

0.050

4

0.067

5

0.083

6

0.100

7

0.117

8

0.133

9

0.150

10

0.167

11

0.183

12

0.200

13

0.217

14

0.233

15

0.250

16

0.267

17

0.283

18

0.300

19

0.317

20

0.333

21

0.350

22

0.367

23

0.383

24

0.400

25

0.417

26

0.433

27

0.450

28

0.467

29

0.483

30

0.500

31

0.517

32

0.533

33

0.550

34

0.567

35

0.583

36

0.600

37

0.617

38

0.633

39

0.650

40

0.667

41

0.683

42

0.700

43

0.717

44

0.733

45

0.750

46

0.767

47

0.783

48

0.800

49

0.817

50

0.833

51

0.850

52

0.867

53

0.883

54

0.900

55

0.917

56

0.933

57

0.950

58

0.967

59

0.983

60

1.000

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×