View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernie Bernie is offline
external usenet poster
 
Posts: 47
Default payroll calculations

I do payroll where I list hours per day I need a formula that when the hours
go over 40 that it will put 40 in one cell and the ammout of overtime in a
cell below it.

Also a formula that will look at other cells such as sick and vacation to be
part of the 40 hour week equation