DECIMAL TIME CONVERSION
How do I convert conventional hours into a decimal number?
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. More
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