Minutes to Hours Converter
Convert minutes to decimal hours, hours and minutes, and HH:MM time format. Useful for payroll, time sheets, work logs, billing, study time, exercise tracking, and project hours.
People used this calculator
Your current platform: —
This total is global for all users (desktop and mobile) using this calculator on calculatorgeek.com.
Direct answer: To convert minutes to hours, divide the number of minutes by 60. For example, 90 ÷ 60 = 1.5 decimal hours, which is 1 hour 30 minutes or 01:30.
Use this minutes to hours converter for decimal hours, hours and minutes, HH:MM or HH:MM:SS, payroll calculations, timesheets, billing, work logs, study time, exercise tracking, scheduling, and project-hour tracking.
Another common answer: 100 minutes equals approximately 1.67 decimal hours, 1 hour 40 minutes, or 01:40. The exact calculation is 100 ÷ 60 = 1.6667 hours, rounded to two decimal places.
What This Minutes to Hours Converter Does
The Minutes to Hours Converter helps you quickly convert any number of minutes into the time format you need.
It shows results in three common formats:
| Format | Example for 345 minutes |
|---|---|
| Decimal hours | 5.75 hours |
| Hours and minutes | 5 hours 45 minutes |
| HH:MM format | 05:45 |
This is helpful because different situations use different time formats. Payroll and timesheets often use decimal hours. Schedules and timers usually use hours and minutes. Digital time records often use HH:MM format.
For example:
| Minutes | Decimal hours | Hours + minutes |
|---|---|---|
| 15 minutes | 0.25 hours | 0 hours 15 minutes |
| 30 minutes | 0.50 hours | 0 hours 30 minutes |
| 45 minutes | 0.75 hours | 0 hours 45 minutes |
| 90 minutes | 1.50 hours | 1 hour 30 minutes |
The calculator can also help with common searches like 40 minutes in decimal, 20 minutes in decimal, 15 minutes in decimal, and minute conversion chart because it gives both the exact calculation and a quick chart-style answer.
For payroll or billing, the decimal result is often the most useful. For example, 30 minutes equals 0.50 hours, not 0.30 hours. This difference matters when you are entering time into payroll software, invoices, work logs, or time-tracking sheets.
The tool also supports reverse-style planning. You can convert:
| Conversion type | Example |
|---|---|
| Minutes to decimal hours | 120 minutes = 2.00 hours |
| Decimal hours to minutes | 1.75 hours = 105 minutes |
| Hours + minutes to decimal | 2 hours 30 minutes = 2.50 hours |
This makes it more complete than a basic minutes calculator because it supports everyday time conversion, payroll-style decimal hours, and quick reference chart use in one place.
Common minute conversions
| Minutes | Decimal hours | Hours + minutes |
|---|---|---|
| 15 | 0.25 | 0 hours 15 minutes |
| 20 | 0.33 | 0 hours 20 minutes |
| 30 | 0.50 | 0 hours 30 minutes |
| 40 | 0.67 | 0 hours 40 minutes |
| 45 | 0.75 | 0 hours 45 minutes |
| 60 | 1.00 | 1 hour |
| 75 | 1.25 | 1 hour 15 minutes |
| 90 | 1.50 | 1 hour 30 minutes |
| 100 | 1.67 | 1 hour 40 minutes |
| 120 | 2.00 | 2 hours |
| 135 | 2.25 | 2 hours 15 minutes |
| 150 | 2.50 | 2 hours 30 minutes |
| 240 | 4.00 | 4 hours |
| 480 | 8.00 | 8 hours |
How to Convert Minutes to Hours
To convert minutes to hours, divide the number of minutes by 60.
hours = minutes ÷ 60
This works because 1 hour has 60 minutes.
Examples:
| Minutes | Calculation | Hours |
|---|---|---|
| 30 minutes | 30 ÷ 60 | 0.50 hours |
| 45 minutes | 45 ÷ 60 | 0.75 hours |
| 60 minutes | 60 ÷ 60 | 1.00 hour |
| 90 minutes | 90 ÷ 60 | 1.50 hours |
| 120 minutes | 120 ÷ 60 | 2.00 hours |
So if you want to convert 345 minutes to hours:
345 ÷ 60 = 5.75 hours
That means:
345 minutes = 5.75 hours
You can also read this as 5 hours and 45 minutes.
A simple way to understand it:
| Part | Meaning |
|---|---|
| 5 full hours | 300 minutes |
| 0.75 hour | 45 minutes |
| Total | 345 minutes |
So the full answer is:
345 minutes = 5.75 hours = 5 hours 45 minutes = 05:45
This formula is the most important rule for any minutes to hours converter, decimal hours calculator, or time conversion chart.
Formula and Methodology
This converter is based on the standard time-unit relationships documented by the NIST Guide to the SI: 1 minute = 60 seconds and 1 hour = 60 minutes = 3,600 seconds.
Formula Used
decimal hours = total minutes ÷ 60 decimal hours with seconds = (minutes × 60 + seconds) ÷ 3,600 full hours = floor(total minutes ÷ 60) remaining minutes = total minutes mod 60
Decimal-hour warning: 1.30 decimal hours is not 1 hour 30 minutes. 1.30 hours = 1 hour 18 minutes, while 1 hour 30 minutes = 1.50 decimal hours.
Precision and Rounding Sequence
- Normalize the input into total seconds or total minutes.
- Calculate the exact decimal-hour value before rounding.
- Round only the displayed result to the selected number of decimal places.
- Apply payroll rounding separately to the time value, not to an already rounded decimal result.
Fractional Minutes, Seconds, and Durations Over 24 Hours
Fractional minutes are preserved during the calculation. Seconds are converted as a fraction of 3,600 seconds per hour. When seconds reach 60, they carry into the next minute; when minutes reach 60, they carry into the next hour. Durations longer than 24 hours remain durations rather than wrapping to a time of day—for example, 1,500 minutes = 25.00 hours = 25:00.
Normal Rounding vs. Payroll Rounding
Normal rounding changes only how many decimal places are displayed after the exact conversion. Payroll rounding changes the time value to a selected interval, such as 5, 6, or 15 minutes, before calculating payroll decimal hours. They are not interchangeable.
For one U.S. federal example, the U.S. Department of Labor FLSA Hours Worked Advisor explains that certain time-clock rounding practices may be acceptable only when they do not result, over time, in employees losing compensable time. Requirements vary by jurisdiction, employer, and contract. This calculator provides mathematical outputs, not legal or payroll advice.
Verification Test Cases
- 90 minutes: 1.5 hours, 1 hour 30 minutes, and 01:30.
- 1,500 minutes: 25 hours and 25:00, confirming durations longer than 24 hours.
- 23 minutes 47 seconds: exact value 0.396389 hours, displayed as 0.40 hours at two decimal places, and 00:23:47.
These cases were checked against the live calculator output by the CalculatorGeek Algorithmic Team.
Minutes to Decimal Hours
Converting minutes to decimal hours is the most important format for payroll, timesheets, billing, and work tracking.
Formula
decimal hours = minutes ÷ 60
This gives you a single number (decimal) instead of hours and minutes.
Common Minute to Decimal Hour Conversions
| Minutes | Decimal Hours |
|---|---|
| 10 | 0.17 |
| 15 | 0.25 |
| 20 | 0.33 |
| 30 | 0.50 |
| 45 | 0.75 |
| 50 | 0.83 |
| 60 | 1.00 |
These are widely used in time sheet systems and payroll software.
Examples
- 15 minutes in decimal = 15 ÷ 60 = 0.25 hours
- 45 minutes in decimal = 45 ÷ 60 = 0.75 hours
- 90 minutes in decimal = 90 ÷ 60 = 1.50 hours
- 125 minutes in decimal = 125 ÷ 60 = 2.08 hours
Why Decimal Hours Matter
Decimal hours are used because they are easier for calculations:
Example (Payroll):
Hourly rate = $20
Time worked = 1.75 hours
Pay = 1.75 × 20 = $35
If you used 1 hour 45 minutes instead, calculation becomes harder.
Common Mistake (Very Important)
❌ Wrong:
45 minutes = 0.45 hours
✅ Correct:
45 ÷ 60 = 0.75 hours
👉 This mistake is extremely common in payroll and can lead to incorrect pay.
Decimal hours are essential for:
- payroll calculations
- billing clients
- tracking work hours
- project time estimation
Minutes to Hours and Minutes (Standard Time Format)
Sometimes you don’t need decimal hours—you need a readable time format like “2 hours 30 minutes”. This is the most natural format for schedules, daily logs, and general use.
Formula
hours = floor(minutes ÷ 60)
remaining minutes = minutes mod 60
- Hours = how many full 60-minute blocks
- Remaining minutes = what’s left after those hours
Examples
| Minutes | Hours | Remaining Minutes | Result |
|---|---|---|---|
| 75 | 1 | 15 | 1 hour 15 minutes |
| 90 | 1 | 30 | 1 hour 30 minutes |
| 125 | 2 | 5 | 2 hours 5 minutes |
| 345 | 5 | 45 | 5 hours 45 minutes |
Step-by-Step Example
Convert 125 minutes:
- Divide by 60 125 ÷ 60 = 2 remainder 5
- Extract values
- Hours = 2
- Minutes = 5
- Final answer:
125 minutes = 2 hours 5 minutes
Why This Format Is Useful
This format is best for:
- daily schedules
- study time tracking
- workout durations
- event timing
It is easier to read and understand quickly compared to decimals.
Important Detail
If minutes are exactly divisible by 60:
- 60 minutes = 1 hour (not 0 hours 60 minutes)
- 120 minutes = 2 hours (not 1 hour 60 minutes)
Relation to Other Formats
| Format | 125 Minutes |
|---|---|
| Decimal hours | 2.08 hours |
| Hours + minutes | 2 hours 5 minutes |
| HH:MM | 02:05 |
This makes it easy to switch between:
- human-readable time
- payroll-ready decimal time
- digital HH:MM format
Minutes to HH:MM Format
The HH:MM format is the standard digital time format used in clocks, apps, spreadsheets, and time-tracking systems.
It represents time as:
- HH = hours
- MM = minutes (always two digits)
Formula
HH = floor(minutes ÷ 60)
MM = minutes mod 60
Examples
| Minutes | HH:MM |
|---|---|
| 15 | 00:15 |
| 45 | 00:45 |
| 75 | 01:15 |
| 90 | 01:30 |
| 125 | 02:05 |
| 345 | 05:45 |
Step-by-Step Example
Convert 125 minutes to HH:MM:
- Divide minutes by 60 125 ÷ 60 = 2 remainder 5
- Format:
- Hours = 2 → 02
- Minutes = 5 → 05
- Final result:
02:05
Important Formatting Rule
Minutes must always be two digits:
- 5 minutes → 05
- 9 minutes → 09
- 0 minutes → 00
Where HH:MM Format Is Used
- digital clocks
- spreadsheets (Excel, Google Sheets)
- time-tracking tools
- work schedules
- timers and apps
Comparison with Other Formats
| Format | 125 Minutes |
|---|---|
| Decimal hours | 2.08 hours |
| Hours + minutes | 2 hours 5 minutes |
| HH:MM | 02:05 |
This format is best when you need standardized time display rather than calculations.
Worked Conversion Examples
135 Billable Minutes at $40 per Hour
Input: 135 minutes. Formula: 135 ÷ 60 = 2.25 hours. Exact and rounded result: 2.25 hours, or 2 hours 15 minutes. Billing example: 2.25 × $40 = $90. Use decimal hours for the charge calculation and keep the original duration in the supporting time record.
8 Hours 41 Minutes for a Timesheet
Input: 8 hours 41 minutes, or 521 minutes. Formula: 521 ÷ 60 = 8.683333… hours. Normal rounded result: 8.68 hours at two decimal places. If a valid nearest-15-minute payroll policy applies, 8:41 rounds to 8:45, or 8.75 hours; do not apply that payroll result unless the relevant workplace and jurisdiction permit it.
23 Minutes 47 Seconds
Input: 23 minutes 47 seconds. Formula: (23 × 60 + 47) ÷ 3,600 = 0.3963889 hours. Rounded result: 0.40 hours at two decimal places. Clock-style result: 00:23:47. Use the exact value for further calculations and the rounded value only for display or a defined reporting rule.
Many common-duration examples already appear in the use-case section, so these worked examples focus on billing, payroll, long-duration, and second-level edge cases that add new information.
Minutes to Hours Conversion Table (1–60 Minutes)
This minutes to hours conversion table gives you a quick reference for converting minutes into decimal hours and HH:MM format without using a calculator.
It is especially useful for:
- payroll and timesheets
- quick conversions during work
- billing and invoicing
- manual time tracking
Quick Conversion Chart
This minutes to hours conversion chart helps you quickly convert 1–60 minutes into decimal hours and HH:MM format. It is useful when you need a quick reference for payroll, timesheets, billing, or manual time tracking.
| Minutes | Decimal Hours | HH:MM |
|---|---|---|
| 1 | 0.02 | 00:01 |
| 2 | 0.03 | 00:02 |
| 3 | 0.05 | 00:03 |
| 4 | 0.07 | 00:04 |
| 5 | 0.08 | 00:05 |
| 6 | 0.10 | 00:06 |
| 7 | 0.12 | 00:07 |
| 8 | 0.13 | 00:08 |
| 9 | 0.15 | 00:09 |
| 10 | 0.17 | 00:10 |
| 11 | 0.18 | 00:11 |
| 12 | 0.20 | 00:12 |
| 13 | 0.22 | 00:13 |
| 14 | 0.23 | 00:14 |
| 15 | 0.25 | 00:15 |
| 16 | 0.27 | 00:16 |
| 17 | 0.28 | 00:17 |
| 18 | 0.30 | 00:18 |
| 19 | 0.32 | 00:19 |
| 20 | 0.33 | 00:20 |
| 21 | 0.35 | 00:21 |
| 22 | 0.37 | 00:22 |
| 23 | 0.38 | 00:23 |
| 24 | 0.40 | 00:24 |
| 25 | 0.42 | 00:25 |
| 26 | 0.43 | 00:26 |
| 27 | 0.45 | 00:27 |
| 28 | 0.47 | 00:28 |
| 29 | 0.48 | 00:29 |
| 30 | 0.50 | 00:30 |
| 31 | 0.52 | 00:31 |
| 32 | 0.53 | 00:32 |
| 33 | 0.55 | 00:33 |
| 34 | 0.57 | 00:34 |
| 35 | 0.58 | 00:35 |
| 36 | 0.60 | 00:36 |
| 37 | 0.62 | 00:37 |
| 38 | 0.63 | 00:38 |
| 39 | 0.65 | 00:39 |
| 40 | 0.67 | 00:40 |
| 41 | 0.68 | 00:41 |
| 42 | 0.70 | 00:42 |
| 43 | 0.72 | 00:43 |
| 44 | 0.73 | 00:44 |
| 45 | 0.75 | 00:45 |
| 46 | 0.77 | 00:46 |
| 47 | 0.78 | 00:47 |
| 48 | 0.80 | 00:48 |
| 49 | 0.82 | 00:49 |
| 50 | 0.83 | 00:50 |
| 51 | 0.85 | 00:51 |
| 52 | 0.87 | 00:52 |
| 53 | 0.88 | 00:53 |
| 54 | 0.90 | 00:54 |
| 55 | 0.92 | 00:55 |
| 56 | 0.93 | 00:56 |
| 57 | 0.95 | 00:57 |
| 58 | 0.97 | 00:58 |
| 59 | 0.98 | 00:59 |
| 60 | 1.00 | 01:00 |
How to Use This Table
- Find your minutes value in the first column
- Read across to get:
- decimal hours (for payroll or billing)
- HH:MM format (for time display)
Why This Table Is Useful
This chart is widely used in:
- payroll systems
- manual time sheets
- invoicing
- quick workplace calculations
It removes the need to calculate every time.
Important Note on Rounding
Decimal values are rounded to 2 decimal places.
For example:
- 50 minutes = 0.83 hours (rounded from 0.8333…)
- 40 minutes = 0.67 hours
Different payroll systems may apply slightly different rounding rules.
Pro Tip
If you frequently convert minutes to hours:
- bookmark this page
- or download the chart as PDF (available in the calculator)
Payroll Rounding Explained
When converting minutes to hours for payroll and timesheets, companies often round time instead of using exact values. This makes calculations faster and aligns with internal policies.
Why Payroll Rounding Is Used
Payroll systems round time to:
- simplify calculations
- standardize reporting
- reduce minor time-entry differences
For example, instead of calculating 0.83 hours for 50 minutes, a company may round it depending on its rule.
Common Payroll Rounding Methods
1. Exact (No Rounding)
This is the most accurate method:
decimal hours = minutes ÷ 60
Example:
- 50 minutes = 0.83 hours
👉 Best for:
- precise billing
- freelance work
- hourly contracts
2. 5-Minute Rounding
Time is rounded to the nearest 5 minutes.
| Actual Time | Rounded Time |
|---|---|
| 12 minutes | 10 minutes |
| 13 minutes | 15 minutes |
👉 Used in:
- basic workplace systems
- manual time logs
3. 6-Minute Rounding (Tenths of an Hour)
This is very common in payroll.
- 6 minutes = 0.1 hour
- 12 minutes = 0.2 hour
- 30 minutes = 0.5 hour
Example:
- 50 minutes ≈ 0.8 hours
👉 Used in:
- billing systems
- consulting
- law firms
4. 15-Minute Rounding (Quarter Hour)
Time is rounded to the nearest 15 minutes.
| Actual Time | Rounded Time |
|---|---|
| 7 minutes | 0 minutes |
| 8 minutes | 15 minutes |
| 22 minutes | 15 minutes |
| 23 minutes | 30 minutes |
👉 Used in:
- traditional payroll systems
- shift-based work
Quick Comparison
| Minutes | Exact Decimal | 6-Minute | 15-Minute |
|---|---|---|---|
| 10 | 0.17 | 0.2 | 0.25 |
| 20 | 0.33 | 0.3 | 0.25 |
| 50 | 0.83 | 0.8 | 0.75 |
Important Payroll Note
Payroll rounding rules vary by employer, country, and labor regulations.
This converter shows mathematical rounding only and should not be considered legal payroll advice.
For one U.S. federal example, see the U.S. Department of Labor FLSA Hours Worked Advisor. It explains that time-clock rounding must not result, over time, in employees losing compensable time; other jurisdictions and workplaces may use different rules.
When to Use Each Method
| Situation | Best Method |
|---|---|
| Freelance / billing clients | Exact decimal |
| Corporate payroll | 6-minute or 15-minute |
| Manual time tracking | 5-minute rounding |
Common Mistake in Payroll
❌ Entering:
50 minutes = 0.50 hours
✅ Correct:
50 minutes = 0.83 hours
👉 This mistake can lead to underpayment or overpayment.
Real-World Use Cases
A minutes to hours converter is not just for math—it solves real problems in everyday work and life. Below are the most common scenarios where accurate conversion matters.
1. Payroll and Timesheets
Employees and employers often record time in minutes but need decimal hours for payroll systems.
Example:
Worked time = 125 minutes
Decimal hours = 125 ÷ 60 = 2.08 hours
This value is entered directly into payroll software.
👉 Used for:
- employee timesheets
- attendance tracking
- hourly wage calculations
2. Freelancing and Client Billing
Freelancers charge clients based on billable hours, not minutes.
Example:
Work time = 90 minutes
Decimal hours = 1.5 hours
Rate = $30/hour
Total = 1.5 × 30 = $45
👉 Important for:
- accurate invoicing
- transparent billing
- project cost estimation
3. Project Time Tracking
Teams track how long tasks take to improve productivity.
Example:
Task duration = 45 minutes
Converted = 0.75 hours
👉 Used in:
- project management tools
- productivity tracking
- performance analysis
4. Study and Learning Time
Students track study sessions in minutes but summarize in hours.
Example:
Study time = 150 minutes
Converted = 2.5 hours
👉 Helps with:
- daily study goals
- exam preparation
- time management
5. Fitness and Exercise Tracking
Workout durations are often recorded in minutes but analyzed in hours.
Example:
Workout = 75 minutes
Converted = 1 hour 15 minutes
👉 Useful for:
- fitness tracking apps
- weekly exercise summaries
- goal setting
6. Scheduling and Event Planning
Event durations are often planned in minutes but displayed in readable time.
Example:
Event = 135 minutes
Converted = 2 hours 15 minutes (02:15)
👉 Used for:
- meetings
- conferences
- appointments
7. Transportation and Travel Time
Travel time is often given in minutes but needs to be understood in hours.
Example:
Travel = 180 minutes
Converted = 3 hours
👉 Helps with:
- trip planning
- commute tracking
- itinerary building
Why These Use Cases Matter
Different industries use different formats:
| Industry | Preferred Format |
|---|---|
| Payroll | Decimal hours |
| Scheduling | HH:MM |
| Daily use | Hours + minutes |
This is why a complete minutes to hours converter must support all formats.
Why Accurate Time Conversion Matters
Whether you’re:
- calculating pay
- billing a client
- tracking time
👉 Accurate conversion ensures:
- correct payments
- better planning
- clear reporting
Common Mistakes When Converting Minutes to Hours
Even though converting minutes to hours is simple, many people make mistakes—especially when dealing with decimal hours and payroll calculations. These errors can lead to incorrect time tracking, billing issues, or payroll discrepancies.
❌ Mistake 1: Treating Minutes as Decimals
Many users assume minutes directly convert into decimal form.
Wrong:
45 minutes = 0.45 hours
Correct:
45 ÷ 60 = 0.75 hours
👉 Minutes are not base-10—they are base-60, so you must divide by 60.
❌ Mistake 2: Writing Invalid Time Formats
Users sometimes mix formats incorrectly.
Wrong:
1 hour 75 minutes
Correct:
2 hours 15 minutes
👉 Minutes must always stay between 0 and 59.
❌ Mistake 3: Forgetting Leading Zeros in HH:MM
Digital formats require consistent formatting.
Wrong:
2:5
Correct:
02:05
👉 Always use two digits for minutes (and often hours).
❌ Mistake 4: Incorrect Payroll Entry
This is one of the most costly mistakes.
Wrong:
30 minutes = 0.30 hours
Correct:
30 ÷ 60 = 0.50 hours
👉 Entering incorrect decimals can result in underpayment or overpayment.
❌ Mistake 5: Ignoring Rounding Rules
Different workplaces use different rounding methods.
Example:
50 minutes = 0.83 hours (exact)
But in some payroll systems:
50 minutes ≈ 0.8 hours (6-minute rounding)
👉 Always check your company’s rounding policy.
❌ Mistake 6: Confusing Decimal Hours with Minutes
Some users misinterpret decimal values.
Example:
1.75 hours ≠ 1 hour 75 minutes
Correct:
1.75 hours = 1 hour 45 minutes
👉 Multiply decimal part by 60 to convert back to minutes:
0.75 × 60 = 45 minutes
Quick Correction Table
| Input | Wrong Assumption | Correct Answer |
|---|---|---|
| 45 minutes | 0.45 hours | 0.75 hours |
| 30 minutes | 0.30 hours | 0.50 hours |
| 1.75 hours | 1h 75m | 1h 45m |
| 125 minutes | 1h 25m | 2h 5m |
Why Avoiding These Mistakes Matters
Incorrect conversions can affect:
- payroll accuracy
- client billing
- project time tracking
- scheduling
Even small errors can add up over time.
Why Minute Conversion Errors Happen
Most errors happen because:
people forget that time uses base-60, not base-10.
Frequently Asked Questions
What is the formula to convert minutes to hours?
Use this formula:
hours = minutes ÷ 60
For example:
- 120 minutes ÷ 60 = 2 hours
What is 45 minutes in decimal hours?
45 ÷ 60 = 0.75 hours
So, 45 minutes = 0.75 hours.
What is 30 minutes in hours?
30 ÷ 60 = 0.50 hours
So, 30 minutes = 0.5 hours.
What is 90 minutes in hours?
90 ÷ 60 = 1.5 hours
So, 90 minutes = 1.5 hours.
How do I convert minutes to hours and minutes?
Divide minutes by 60:
- The whole number = hours
- The remainder = minutes
Example:
125 minutes = 2 hours 5 minutes
How do I convert decimal hours back to minutes?
Multiply by 60:
minutes = decimal hours × 60
Example:
1.75 × 60 = 105 minutes
Is 0.5 hours equal to 50 minutes?
❌ No
0.5 hours = 30 minutes
Why is 60 used in time conversion?
Time is based on a base-60 system, which dates back to ancient civilizations. That’s why:
- 1 hour = 60 minutes
- 1 minute = 60 seconds
What is a minutes to decimal conversion chart?
A minutes to decimal chart shows common conversions like:
| Minutes | Decimal Hours |
|---|---|
| 15 | 0.25 |
| 30 | 0.50 |
| 45 | 0.75 |
| 60 | 1.00 |
It helps you convert time quickly without calculations.
Which format should I use: decimal or HH:MM?
| Use Case | Best Format |
|---|---|
| Payroll / billing | Decimal hours |
| Scheduling | HH:MM |
| General use | Hours + minutes |
Can I round minutes when converting to hours?
Yes, depending on your use case:
- Exact: divide by 60
- Payroll: may use 5-minute, 6-minute, or 15-minute rounding
Always follow your company’s rules for payroll calculations.
Is 1.30 hours the same as 1 hour 30 minutes?
No. 1.30 decimal hours equals 1 hour 18 minutes because 0.30 × 60 = 18. 1 hour 30 minutes equals 1.50 decimal hours.
How do I include seconds?
Convert the full duration to seconds, then divide by 3,600. For example, 23 minutes 47 seconds is 1,427 seconds, and 1,427 ÷ 3,600 = 0.3963889 hours, or 0.40 hours rounded to two decimals.
What is the Excel formula for converting minutes to hours?
If cell A1 contains minutes, use =A1/60 for decimal hours. To display the result as a time duration, use =A1/1440 and apply an hours-and-minutes number format.
How do I display durations longer than 24 hours in Excel?
Use a bracketed duration format such as [h]:mm. The brackets prevent Excel from wrapping the displayed hours back to zero after each 24-hour period.
References
Below are authoritative sources used for time conversion rules, decimal hours, and payroll-related practices:
- National Institute of Standards and Technology (NIST). NIST Guide to the SI, Chapter 5: Units Outside the SI
- OpenStax. Physical Quantities and Units, College Physics 2e
- U.S. Department of Labor. FLSA Hours Worked Advisor: Recording and Rounding Time (U.S. federal example; payroll rules vary by employer, contract, and jurisdiction.)
