Timesheet Unsocial Hours

AppSheet AppSheet Q&A
1

I am working on a timesheet app to help calculating payroll that has unsociable hours payments within it.

Monday - Friday 0700-2000 is normal rate

Monday - Friday 2000-0700 is normal rate +43%

Saturday 0700-2359 is normal rate + 43%

Sunday 0000 - 0700 Monday is normal rate + 88%

I am struggling to build an expression that will assist summing worked hours based on the above criteria.

Columns that I have are day(text), Date, start time, end time, worked hours. Any help would be greatly appreciated.

2

Hey,

maybe something like that?

Day formula expression:
SWITCH(WEEKDAY([Date]), 1, “Sunday”, 2, “Monday”, 3, “Tuesday”, 4, “Wednesday”, 5, “Thursday”, 6, “Friday”, 7, “Saturday”, “”)

Date initial value:
TODAY()

start time initial value:
TIMENOW()

worked hours formula expression:
TOTALHOURS(IF([end time] > [start time], [end time] - [start time], DATETIME(CONCATENATE(([Date]+1), " ", [end time])) - DATETIME(CONCATENATE([Date], " ", [start time]))))

Cheers

2 Likes