Right now I am using a number of columns to calculate the hourly
overtime rate:
Illustration as follows
A1 -- B1 -- C1 -- D1 -- E1 --- F1
Basic -- Days -- Per day -- Per Hr -- No of Hrs -- Amt
1200 -- 26 -- 8 -- 5.76 --
Currently I used A1 div B1 div C1 to get 5.76
Is there a way of shortening to arrived at the per hour formula
and also to cap the rate at 11.00 if it exceeds 11.00. If the calculated
rate falls below 11.00 the calculated rate will apply.
26 and 8 will always remains unchanged.
Thanks again
Thong
overtime rate:
Illustration as follows
A1 -- B1 -- C1 -- D1 -- E1 --- F1
Basic -- Days -- Per day -- Per Hr -- No of Hrs -- Amt
1200 -- 26 -- 8 -- 5.76 --
Currently I used A1 div B1 div C1 to get 5.76
Is there a way of shortening to arrived at the per hour formula
and also to cap the rate at 11.00 if it exceeds 11.00. If the calculated
rate falls below 11.00 the calculated rate will apply.
26 and 8 will always remains unchanged.
Thanks again
Thong
Last edited: