CONVERT TOTAL HOURS TO REGULAR AND OVERTIME

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

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

http://www.cpearson.com/excel/overtime.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"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

Hi Mark

in C2
=MIN(8,B2)*(B2>0)
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