View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
justnotgettingit justnotgettingit is offline
external usenet poster
 
Posts: 2
Default How to Sum<=40, sum, if 40 sum in next column

I am trying to sum a column of hours and minutes to calculate straight hours
and overtime. If the sum is <=40, then sum; otherwise move excess to the
next column. What is the foluma I should use to do this. I'm stumped.