Hours to decimal, both ways.
Payroll wants 7.75, your timesheet says 7:45. Divide the minutes by 60 and add them to the hours — or let this do it for a whole column.
Convert one value
= 7.75 decimal hours
= 7:45 hours and minutes
Convert a whole sheet
Paste a column from your timesheet. HH:MM or decimal.
| Entered | Decimal | HH:MM |
|---|---|---|
| 8:15 | 8.25 | 8:15 |
| 7:45 | 7.75 | 7:45 |
| 9:30 | 9.50 | 9:30 |
| 6:50 | 6.83 | 6:50 |
| 8:00 | 8.00 | 8:00 |
| Total | 40.33 | 40:20 |
Minutes to decimal hours chart
Each minute is 1/60 of an hour, so 15 minutes is 0.25 and 45 minutes is 0.75.
1 min0.02
2 min0.03
3 min0.05
4 min0.07
5 min0.08
6 min0.10
7 min0.12
8 min0.13
9 min0.15
10 min0.17
11 min0.18
12 min0.20
13 min0.22
14 min0.23
15 min0.25
16 min0.27
17 min0.28
18 min0.30
19 min0.32
20 min0.33
21 min0.35
22 min0.37
23 min0.38
24 min0.40
25 min0.42
26 min0.43
27 min0.45
28 min0.47
29 min0.48
30 min0.50
31 min0.52
32 min0.53
33 min0.55
34 min0.57
35 min0.58
36 min0.60
37 min0.62
38 min0.63
39 min0.65
40 min0.67
41 min0.68
42 min0.70
43 min0.72
44 min0.73
45 min0.75
46 min0.77
47 min0.78
48 min0.80
49 min0.82
50 min0.83
51 min0.85
52 min0.87
53 min0.88
54 min0.90
55 min0.92
56 min0.93
57 min0.95
58 min0.97
59 min0.98
60 min1.00