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.
To convert hours using Excel:
Change the cell format to "Number" with 2 decimal places and multiply it by 24
See long answer (that should take the user to Long Answer, under this 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:

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.

Example:

Step 1 In cell A1 Type 4:23
Step 2 In cell B1 Type =(A1)*24
Step 3 Change the format of cell B to "Number" with 2 decimal places. You will now see 4.38
To pay your worker, enter in cell C1 =(b1*13.50)

Download
Our Apps