Payroll travel-time pay worksheet calculator

Calculate included travel hours before deduction and excluded travel hours with your own figures.

Your numbers

Use the units shown. Results update as you change valid inputs.

Choose the currency for these amounts. Changing it keeps your numbers and does not convert exchange rates.

Use included travel hours before deduction and excluded travel hours to compare changes to your inputs. The method and limits below explain the scope.

Examples

Examples

Try the starting example

Travel legs: name, minutes, include under supplied rule yes/no
Outbound,60,yes Between sites,30,yes Return,60,yes Other,20,no
Additional ordinary-commute deduction minutes
60
Flat payable travel hourly rate ($)
15
Included travel hours before deduction
2.5
Excluded travel hours
0.333333
Additional deducted hours
1
Remaining payable travel hours
1.5
Flat travel-pay illustration ($)
$22.50

Try another scenario

Travel legs: name, minutes, include under supplied rule yes/no
Outbound,60,yes Between sites,30,yes Return,60,yes Other,20,no
Additional ordinary-commute deduction minutes
0
Flat payable travel hourly rate ($)
15
Included travel hours before deduction
2.5
Excluded travel hours
0.333333
Additional deducted hours
0
Remaining payable travel hours
2.5
Flat travel-pay illustration ($)
$37.50
Calculation method

Calculation method

Included travel hours before deduction

Sum minutes explicitly marked include yes/60.

Excluded travel hours

Sum include no minutes/60.

Additional deducted hours

min(entered commute deduction,included minutes)/60.

Remaining payable travel hours

max(0,included minutes−entered deduction)/60.

Flat travel-pay illustration ($)

Remaining payable minutes×entered rate/60.

Symbols and units
a
Travel legs: name, minutes, include under supplied rule yes/no
b
Additional ordinary-commute deduction minutes
c
Flat payable travel hourly rate ($)

Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.

Assumptions & limits

Assumptions & limits

  • A supplied travel-pay rule, with inclusion and commute deduction chosen externally. It does not determine compensable travel, commuting law, overtime or expense reimbursement.
Are these inputs private?

These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.

Further reading

US Department of Labor: pay/time recordkeeping background; actual rules vary ↗

Background reading; this does not imply endorsement or independent review of SumFizz.

Share this page
Share this calculator

Leave unchecked to share the page without your entered values.