Thread: How to seperate OT and Reg. Hours from total hours
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default How to seperate OT and Reg. Hours from total hours
Chip Pearson covers this material at his site.

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


Gord Dibben MS Excel MVP

On Tue, 22 Aug 2006 16:03:12 -0700, cmc1111
wrote:

I am setting up an employee spread sheet for tracking and billing hours
worked. What I would like to do is enter the total daily hours an employee
works and have Excel seperate and quantify both regular hours and OT hours.
What function can I use to sum daily hours equal to or less than 8 hours, and
sum everything over 8 hours seperately.

Reply With QuoteReply With Quote