Quick answer
Time % = (part ÷ total) × 100, with part and total in the same time unit and total > 0.
Formula
- Time % = (a ÷ b) × 100
- Percentage of hours = (hours worked ÷ hours expected) × 100
- Minutes form: (minutes part ÷ minutes total) × 100
Introduction
Every attendance sheet, schedule review, and time budget eventually uses the same core fraction: part divided by total, scaled to a percent.
The Time Percentage Calculator applies this formula when you enter hours as a and b. This article explains the notation, the steps behind the symbol, and the mistakes that break otherwise correct arithmetic.
If you need the concept first, read what is a time percentage, then return here for formula detail.
Overview
Let a represent the part duration and b the total duration. Both must be positive time measures in matching units.
The expression (a ÷ b) is a pure ratio. Multiplying by 100 re-expresses that ratio on a percent scale people use in grades, KPIs, and reports.
Percentage of hours is everyday language for the same structure when a counts worked or present hours and b counts scheduled or expected hours.
Time conversion formula steps belong before division: convert clock readings or minutes into a single unit, then divide. Skipping conversion is the top source of wrong answers.
Formula
- Time % = (a ÷ b) × 100
- Percentage of hours = (hours worked ÷ hours expected) × 100
- Minutes form: (minutes part ÷ minutes total) × 100
Algebraic form: Time% = 100 × (a / b). Spreadsheet form: =100*(A1/B1) or =A1/B1 with percent number format.
When b = 0 the expression is undefined. When a = 0 the time percentage is 0%. When a = b the time percentage is 100%.
Decimal hours are valid: 1.25 hours with 5 hours total gives (1.25 ÷ 5) × 100 = 25%.
For a full calculation walkthrough, see how to calculate time percentage. For spreadsheet setup, see time percentage in Excel.
Step-by-step
- Write the formula in words. Time percentage equals part duration divided by total duration, multiplied by 100.
- Convert to one unit. Example: 45 minutes as part and 3 hour total becomes 0.75 hour part and 3 hour total, or 45 minutes and 180 minutes.
- Compute a ÷ b. Use a calculator for repeating decimals. Keep extra precision until the final step if you are aggregating many rows.
- Multiply by 100. Attach context when you report: percent of shift, percent of term, percent of sprint budget.
- Sanity-check direction. If you meant "what share is 8 of 2" you inverted part and total. The larger duration is usually b for share questions.
- Compare against a tool. Enter the same values in the Time Percentage Calculator to confirm manual work.
Worked example
Given a = 4.5 hours and b = 6 hours: (4.5 ÷ 6) × 100 = 75%.
Given 90 minutes part and 480 minutes total: (90 ÷ 480) × 100 = 18.75%.
Given 0 hours part and 8 hours total: 0%. Given 8 hours part and 8 hours total: 100%.