Quick answer

=(part_cell/total_cell)*100 or =part/total with percent format; same-unit cells required.

Formula

  • =(A2/B2)*100
  • =IF(B2=0,0,A2/B2) with percent format
  • Google Sheets uses the same syntax

Introduction

Spreadsheets are where time percentages scale from one shift to hundreds of rows. The math is still (part ÷ total) × 100.

Excel adds structure: reusable formulas, shared templates, and conditional formatting for thresholds.

Validate sample rows with the Time Percentage Calculator before you distribute a workbook.

Manual methods live in how to calculate time percentage.

Overview

Store durations as numbers, not text. Text breaks AVERAGE and division.

Put part hours in column A and total hours in column B for a simple layout.

Use a header row that states the reference window so future editors do not change b accidentally.

Percent number format multiplies decimals by 100 for display; the formula may return a decimal if you skip *100.

Formula

  • =(A2/B2)*100
  • =IF(B2=0,0,A2/B2) with percent format
  • Google Sheets uses the same syntax

Basic: =100*A2/B2 returns 62.5 when A2=5 and B2=8.

Safe: =IF(B2=0,"",100*A2/B2) avoids divide-by-zero.

Fill down the formula only after locking cell references with $ when needed.

Google Sheets and Excel both accept these patterns; test in your environment if you use international separators.

Step-by-step

  1. Set up columns. A: part hours, B: total hours, C: formula, D: notes.
  2. Enter the formula in C2. =IF(B2=0,0,100*A2/B2) is a dependable starter.
  3. Format column C. Number or Percent format depending on whether you multiplied by 100 in the formula.
  4. Fill down for all rows. Double-check that b changes when the reference window changes per row.
  5. Add conditional formatting (optional). Highlight rows above 100% or below a policy threshold.
  6. Spot-check three rows on the web calculator. Pick min, median, and max ratios to catch inversion errors.

Worked example

Row: worked 36, scheduled 40 → 90%.

Row: present 6.5, expected 7 → about 92.86%.

Template tip: separate sheets per month with identical formulas, different data.

Error tip: if you see 6250% you likely formatted an already multiplied value as percent again.