View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marjolyn Noble
 
Posts: n/a
Default HLookup and how it works

I am currently designing a timesheet template so that it will automatically
dissect total hours worked into Ordindary Hours (max 7.6hr per day, Time&Half
next 3 hrs, and the balance will be Double time). I'm not sure which would be
the best function to assist. I have used the=IF function but there are
flaws. Can anyone suggest which function woulb be more appropraite? Thanks