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.
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
User | Count |
---|---|
43 | |
28 | |
23 | |
14 | |
14 |