Thread: How to Sum<=40, sum, if 40 sum in next column
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default How to Sum<=40, sum, if 40 sum in next column
Regular hours:
=MIN(SUM(A1:A5),40)

OT hours:
=MAX(SUM(A1:A5)-40,0)


"justnotgettingit" wrote:

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.
Reply With QuoteReply With Quote