@m365newuser ,
The Default StartOfWeek is Sunday unless you specify otherwise and this is day 1 with Saturday 7 (hence my code).
The other two are only place holders showing you where to put in your calculation code. I have used names on the controls (In/Out Date/Hour/Minute) that you will have to replace with yours, but I am sure you will get the idea
With(
{
wTime:
DateDiff(
InDate.SelectedDate +
Time(
Value(InHour.Selected.Value),
Value(InMinute.Selected.Value),
0
),
OutDateValue2.SelectedDate +
Time(
Value(OutHour.Selected.Value),
Value(OutMinute.Selected.Value),
0
),
Hours
)
},
If(
WeekDay(OutDate.SelectedDate) = 1 ||
WeekDay(OutDate.SelectedDate) = 7,
wTime*YourWekendRate,
wTime*YourWeekdayRate,
)
)
You may also have to use Minutes instead of Hours and divide your rate by 60 if you want partial hours.
