I am trying to write a formula where if tasks occur on a weekend the normal pay rate is double.
Currently it is as such
HOURS*60 which would calculate the hours/normal rate of 60. however if the work is done on the weekend the pay rate would be 120.
...