Formula for different pay rate on weekends only

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.

+16

Hi @Sean_Mahoney,
You can use the Weekday() formula for this it will return a number for the day of the week 0-6, 0 for sunday and 6 for saturday.

IF(OR(WEEKDAY({Pay Date})=0, WEEKDAY({Pay Date})=6), {Total Hours}*120, {Total Hours}*60)

Sign up