In cell G6,
In cell H6,
I want to figure out formulas for calculating overtime for 'time-and-a-half' (in one column, G6) and one for 'double' (in another column, H6). Any hours over eight (8) are time-and-a-half, and over twelve (12) as double time. I also have a column (I6) that sums the amount for total overtime paid. I attached my Excel file if it helps. Thanks.
Welcome to Ozgrid. Try this amendment & additional formula
There are currently 1 users browsing this thread. (0 members and 1 guests)