Formula for different pay rate on weekends only

[Sean_Mahoney]

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.

Airtable

Grid view - Airtable

Explore the "Grid" view on Airtable.

[Vivid-Squid]

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)