### DECIMAL TIME CONVERSION

**Question:**How do I convert conventional hours into a decimal number?

**Short Answer:**

To convert hours using a calculator:

Divide the minutes by 60.

Divide the minutes by 60.

To convert hours using Excel:

Change the cell format to "Number" with 2 decimal places and multiply it by 24.

Change the cell format to "Number" with 2 decimal places and multiply it by 24.

__See long answer below the chart.__Minutes

Decimal

1

=

0.02

2

=

0.03

3

=

0.05

4

=

0.07

5

=

0.08

6

=

0.1

7

=

0.12

8

=

0.13

9

=

0.15

10

=

0.17

11

=

0.18

12

=

0.2

13

=

0.22

14

=

0.23

15

=

0.25

16

=

0.27

17

=

0.28

18

=

0.3

19

=

0.32

20

=

0.33

21

=

0.35

22

=

0.37

23

=

0.38

24

=

0.4

25

=

0.42

26

=

0.43

27

=

0.45

28

=

0.47

29

=

0.48

30

=

0.5

Minutes

Decimal

31

=

0.52

32

=

0.53

33

=

0.55

34

=

0.57

35

=

0.58

36

=

0.6

37

=

0.62

38

=

0.63

39

=

0.65

40

=

0.67

41

=

0.68

42

=

0.7

43

=

0.72

44

=

0.73

45

=

0.75

46

=

0.77

47

=

0.78

48

=

0.8

49

=

0.82

50

=

0.83

51

=

0.85

52

=

0.87

53

=

0.88

54

=

0.9

55

=

0.92

56

=

0.93

57

=

0.95

58

=

0.97

59

=

0.98

60

=

1

Long answer

### USING A CALCULATOR:

If you need to pay a worker in a hurry, and would like to use a calculator, here is what you can do to convert the time to a decimal number:

Step 1: Divide the minute portion of the time worked into 60.

Step 2: Add the decimal number obtained to the hour portion.

Example: My worker worked for 4hr 23 min at a rate of $13.50. How much do I pay him?

Step 1: Divide: 23 / 60 = 0.38

Step 2: Add: 4 + 0.38 = 4.38

To pay your worker, multiply 4.38 by $13.50

### USING EXCEL:

If you like to use excel:

Step 1: In cell A1, Enter the time as hh:mm

Step 2: In Cell B1, type =(A1)*24

Step 3: Change the format of Cell B to "Number" with 2 decimal places.

Our Apps