If say the hourley wage if £15 and hour, and the hours are in cell a1

=IF(A1<=30,15*A1,22.5*A1)

of course you could and should have the hourley rate in a cell

--

_______________________
Naz,
London


"Excel overtime formula" wrote:

I need to write an excel formula that calculates hourly wages up to 30 hours
and then time and a half after 30 hours in one formula.