How to Convert 100 Minutes to Hours Decimal

To convert 100 minutes to hours in decimal, divide 100 by 60, which gives 1.67 hours, because one hour equals 60 minutes and decimal hours measure the fraction of an hour, not the minutes themselves. Convert any minute value instantly with our free minutes to hours converter.

Try it now: convert/minutes-to-hours →

The Formula: Decimal Hours Equal Minutes Divided by 60

The whole conversion is one division: decimal hours equal minutes divided by 60, because an hour contains 60 minutes and decimal hours express a duration as a single number of hours with a fractional part. For 100 minutes, the division is 100 divided by 60, which equals 1.6667 when rounded to four decimal places, so 100 minutes is 1.67 hours to two decimal places, or 1.6667 hours when more precision is needed. The whole number before the decimal point counts complete hours, and the decimal part counts the fraction of the next hour, so 1.67 means one full hour plus about two thirds of another hour, which is about 40 minutes, and the exact check, 0.6667 times 60, is 40. The most common alternative people try is dividing by 100, which would give 1.00 for 100 minutes, and that answer is wrong by a full 40 minutes, because it treats an hour as if it had 100 minutes, which it does not. If you remember only one thing from this guide, remember divide by 60, and every minute value you meet, from a 15-minute call to a 480-minute workday, converts with the same single step. The formula also runs in reverse: decimal hours times 60 gives minutes, so 1.67 times 60 returns about 100, and that round trip is the check that proves the division was right.

Try it now: convert/minutes-to-hours →

Worked Examples: 100 Minutes and the Landmarks Around It

Worked examples make the formula stick, because the landmarks around 100 minutes show the pattern instead of a single isolated answer. Fifteen minutes is 15 divided by 60, or 0.25 hours, a quarter of an hour. Thirty minutes is 30 divided by 60, or 0.5 hours, exactly half an hour. Forty-five minutes is 45 divided by 60, or 0.75 hours, three quarters of an hour. Sixty minutes is 60 divided by 60, or 1 hour, the anchor everything else hangs from. Seventy-five minutes is 75 divided by 60, or 1.25 hours, and 90 minutes is 90 divided by 60, or 1.5 hours. One hundred minutes is 100 divided by 60, or 1.6667 hours, the first landmark that does not land on a clean quarter, which is why it trips people up: the repeating 6 means the decimal never terminates, so the practical answer is 1.67 hours, rounded to two places, and the rounding rule matters, covered below. One hundred and twenty minutes is 120 divided by 60, or 2 hours exactly, and 150 minutes is 150 divided by 60, or 2.5 hours. Notice that every quarter-hour lands on a clean decimal, 0.25, 0.5, 0.75, and 1.0, while values between quarters repeat or trail off, which is why payroll systems round to quarters or tenths instead of carrying four decimals. Our guides to converting 20 minutes to decimal hours and converting 45 minutes to decimal hours use the same landmarks for their own values.

The 1.67 Trap: Why 1.67 Hours Is Not 1 Hour 67 Minutes

The single most expensive mistake with decimal hours is reading 1.67 as 1 hour and 67 minutes, and it happens because the decimal point looks like a separator between hours and minutes, which it is not. In decimal hours, the digits after the point are a fraction of an hour, so 0.67 means about two thirds of 60 minutes, which is 40 minutes, not 67 minutes, and 67 minutes cannot appear in any correct reading at all, because an hour holds only 60 minutes. The correct reading of 1.67 hours is one hour plus 40 minutes, which totals 100 minutes, and the check is simple: 1 hour is 60 minutes, plus 40 minutes, equals 100 minutes. The wrong reading, 1 hour and 67 minutes, totals 127 minutes, which is 27 minutes too many, and on a timesheet that error overstates a shift by nearly half an hour. The trap runs in the other direction too: 1 hour and 40 minutes is not 1.40 hours, it is 100 divided by 60, or 1.67 hours, because 40 minutes is 40 sixtieths of an hour, not 40 hundredths. A reliable habit is to convert back every time: multiply the decimal part by 60 to recover the minutes, so 0.67 times 60 is about 40, 0.25 times 60 is 15, and 0.5 times 60 is 30, which confirms the reading before the number reaches a payroll system. Our guide to converting 90 minutes to decimal hours shows the same trap at 1.5 hours, where the misreading is 1 hour 50 minutes.

Payroll and Timesheets: The 6-Minute Tenth-Hour Rule

Payroll is where 100 minutes to decimal hours stops being a classroom exercise and starts affecting pay, because many employers round time to the nearest tenth of an hour, which is 6 minutes, instead of the nearest quarter hour, which is 15 minutes. Under tenth-hour rounding, 100 minutes, which is 1.6667 hours, rounds to 1.7 hours, because the second decimal, 6, rounds the first decimal up, and that 1.7 hours is the figure that reaches the pay calculation. Under quarter-hour rounding, the same 100 minutes rounds to 1.75 hours, because 100 minutes sits between 90 minutes, which is 1.5 hours, and 105 minutes, which is 1.75 hours, and 100 is closer to 105 than to 90, so the quarter rule gives a different answer from the tenth rule, and neither is wrong: the employer's written policy decides which one applies. The rule that matters legally in the United States is that rounding must average out over time and must not systematically favor the employer, so a system that always rounds down is not a rounding rule at all, it is underpayment. Always check the written policy before assuming a rounding rule, and keep the unrounded minutes alongside the decimal hours until the pay period closes, because the raw minutes are the evidence if a total is disputed. For a shift that is exactly 100 minutes, the safest record is all three numbers together: 100 minutes, 1.6667 hours unrounded, and the rounded figure the policy requires.

How to Convert Minutes to Decimal Hours in Excel and Google Sheets

In a spreadsheet, the conversion is a formula, not a typed answer, so it stays correct when the minutes change. If the minutes are in cell A1, the decimal hours formula is =A1/60, and formatting the result cell to two decimal places shows 100 as 1.67, 90 as 1.50, and 50 as 0.83. For a whole column of timesheet entries, enter the formula once and fill it down, and the row references adjust automatically, which beats converting each row by hand and removes the transcription errors that creep in after the tenth row. A second formula converts the other way: if decimal hours are in B1, the minutes are =B1*60, so 1.67 times 60 returns about 100, which is the round-trip check that proves the first formula was right, allowing for the small rounding difference between 1.67 and the exact 1.6667. One spreadsheet trap deserves a warning: Excel also stores clock times as fractions of a day, so a cell formatted as a time showing 1:40 means 1 hour and 40 minutes, not 1.40 hours, and multiplying a clock-time cell by 24 is the step that turns it into decimal hours. Mixing those two representations, typing 1.40 into a clock-time cell or treating a clock time as a decimal, is the spreadsheet version of the 1.67 trap above. Our guide to converting minutes to hours in Excel walks through the clock-time format in full, with the fill-down method for a full timesheet.

Common Mistakes That Break Decimal Hour Conversions

Five mistakes account for almost every wrong decimal-hours answer, and each one is easy to spot once it is named. First, dividing by 100 instead of 60, which gives 1.00 for 100 minutes and understates the time by 40 minutes. Second, reading the decimal as minutes, turning 1.67 into 1 hour 67 minutes, covered above, which overstates the time by 27 minutes and invents minutes an hour cannot hold. Third, rounding before the final step, such as rounding 100 divided by 60 to 2 and then multiplying, which destroys the answer. Fourth, dropping the unit, so a bare 1.67 could be hours, days, or anything else, and the next person to read it guesses wrong. Fifth, converting the wrong direction, multiplying by 60 when the question asked for division, which turns 100 minutes into 6,000 of something meaningless. A final check catches all five: convert back, multiply the decimal hours by 60, and confirm the minutes you started with, because 1.67 times 60 is about 100, and any result far from 100 means one of the five mistakes happened. Keep that check as a habit, and decimal hours become a one-step conversion you can trust on a timesheet, an invoice, or a class schedule, rather than a number you hope is right. If you are writing up the timesheet notes to go with the numbers, our free word counter keeps the notes inside any character limit the form sets, while the numbers stay exact.