Calculation

Excel formula

Overtime | # gomaths.net/4219    User submitted, thanks to

Calculate pay for normal hours, time-and-a-half and double-time.

Salary to pay | # gomaths.net/4218    User submitted, thanks to

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

Calculate weekly wage given hours worked and hourly rate.

=B2*C2

where B2 is the hours worked and C2 is the hourly rate