CONVERT TOTAL HOURS TO REGULAR AND OVERTIME
Hi Mark
in C2
=MIN(8,B2)*(B20)
In D2
=B2-C2
Copy down as far as required
--
Regards
Roger Govier
"Mark" wrote in message
...
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
|