Hi,
I'm trying to make an overtime calculator as follows:
-it calculates 40hrs per week at $11 per hour (constant every week) unless it's short week e.g. 35hrs than it calculates 35hrs at $11 per hour
-any hours over 40hrs are overtime and are calculated at $16 per hour
I can't figure out the "if" statement for this calculation.
Can somebody help me? My work file is attached.
Bookmarks