Help with calculating time and a half - I've got straight time and double time.
"Paxton31" wrote:
Straight time is up to 8 hours
Time and a half between 8 and 12 hours
Double time - any hours after 12
[....]
B2 - In
C2 - out
D2 - In
E2 - Out
F2 - Regular time
G2 - Time and a half
H2 - Double time
F2: =MIN(8,(C2-B2+E2-D2)*24)
G2: =MIN(4,(C2-B2+E2-D2)*24 - F2)
H2: =(C2-B2+E2-D2)*24 - F2 - G2
Note: I assume that B2, C2, D2 and E2 have date and time, or midnight does
occur between B2 and C2 or between D2 and E2. Right?
|