View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nucera Nucera is offline
external usenet poster
 
Posts: 1
Default Calculating hours between 35 and 40

We have a 35 hour work week. I am trying to calculate the number of hours
between 35-40, then number of hours between 35-40 if over 40, and if under
35, then it shows 0. I can do it with 2 formulas on seperate lines then
doing an IF statement, but waswondering if it is possible to do it as 1
function.

Thanks.
--
Thank you!