Calculation
Excel formula
Hover over image for animation
Overtime | # gomaths.net/4219 User submitted, thanks to Simon Job
Calculate pay for normal hours, time-and-a-half and double-time.
Salary to pay | # gomaths.net/4218 User submitted, thanks to Simon Job
Calculate weekly, fortnightly and monthly pay from a given salary.
=A1/52 (for weekly)
=A1/26 (for fortnightly)
=A1/12 (for monthly)
where A1 is the salary (per annum)
Weekly wage | # gomaths.net/4217 User submitted, thanks to Simon Job
Calculate weekly wage given hours worked and hourly rate.
=B2*C2
where B2 is the hours worked and C2 is the hourly rate
