Timesheet Converter

1. Using the timesheet converter
2. Timesheet conversion examples
• Time to decimal conversion
• Minutes to decimal conversion
• Hours to decimal conversion
3. Minutes to decimal conversion chart

    Using the timesheet converter

This versatile conversion tool can be used to convert a time expressed in hours and/or minutes to a decimal number of hours or minutes. Likewise, it can be used to convert a decimal number of hours or minutes into hh:mm formatted time. Such calculations are typical when dealing with payroll timesheets, a.k.a. work hour timesheets. We would generally recommend using our timesheet calculator as it automatically converts your entered work hours into a nice print-ready time card.

An example use is to select "time to decimal", then enter "7" in the hours field and "15" in the minutes field. The tool will automatically convert this to 7.25 hours in the output field. In another example, if a timesheet decimal value is 6.75 and you want it in number of hours and minutes, simply choose "decimal to time", then enter "6.75" and the tool will output "6 hours, 45 minutes" in the fields below.

    Timesheet conversion examples

There are many possible conversions supported in our payroll converter above. Some selected examples follow.

Time to decimal conversion

Example task: a worker has clocked 6 hours and 45 minutes on the job. How many hours is this in decimal hours?

Solution: six hours is just six hours, so we keep that as is. 45 minutes is 45/60 = .75 hours. The result is then simply 6.75 hours.

Minutes to decimal conversion

Example task: how many hours is 15 minutes?

Solution: one hour contains 60 minutes, therefore the task is to figure out the ratio of 15 to 60. 15/60 = 0.25 hours meaning 15 minutes is 0.25 hours.

Hours to decimal conversion

Example task: an event lasted for 2 hours and 30 minutes. How many hours did it last?

Solution: 30 minutes in hours equals 0.5 hours, so adding 0.5 to 2 equals 2.5 hours. Converted into minutes that is 2.5 x 60 = 150 minutes.

    Minutes to decimal conversion chart

Timesheet conversion is a straightforward process, but it can be tricky to convert minutes to decimal. A timesheet conversion table is handy in such situations:

Minute to decimal conversion

Minute	Decimal	Minute	Decimal
1	.02	31	.52
2	.03	32	.53
3	.05	33	.55
4	.07	34	.57
5	.08	35	.58
6	.10	36	.60
7	.12	37	.62
8	.13	38	.63
9	.15	39	.65
10	.17	40	.67
11	.18	41	.68
12	.20	42	.70
13	.22	43	.72
14	.23	44	.73
15	.25	45	.75
16	.27	46	.77
17	.28	47	.78
18	.30	48	.80
19	.32	49	.82
20	.33	50	.83
21	.35	51	.85
22	.37	52	.87
23	.38	53	.88
24	.40	54	.90
25	.42	55	.92
26	.43	56	.93
27	.45	57	.95
28	.47	58	.97
29	.48	59	.98
30	.50	60	1.00

How to read the table: say your are interested to express 30 minutes in hours. Simply look at the row for which the Minutes column says "30", then look to the cell to the right of it, which is 0.5, meaning 30 minutes is 0.5 hours. Likewise, to get 45 minutes in hours simply look up the cell in the Minutes column which says "45", then shift one cell to the right and you will see it equals 0.75 hours.