View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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