View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default CONVERT TOTAL HOURS TO REGULAR AND OVERTIME

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