View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
 
Posts: 1,240
Default Payroll calculations for real time

orlcgm wrote:
I need a formula so that I can calculate the true hours including overtinme
at time and a half... how do I separate the overtime them add the regular
hours and calculate the hours of overtime by .5 and add it to the regular
hours??


How do you define "overtime"? Greater than 8 hours in one day, greater than 40
hours in a week, some combination of both?