CONVERT TOTAL HOURS TO REGULAR AND OVERTIME
Are all the Regular hours 8 or less?
In the Regular column (column C??):
=min(8,b2)
In the OT column:
=b2-c2
where b2 holds the Total hours.
Mark wrote:
I am trying to create a spreadsheet that converts the total hours worked in 1
column into two sepate columns that show the total regular and total overtime
NAME TOTAL REG OT
employee 1 10 8 2
employee 2 06 6 0
employee 3 12.5 8 4.5
--
Dave Peterson
|