Thread: How to Sum<=40, sum, if 40 sum in next column
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default How to Sum<=40, sum, if 40 sum in next column
With hours:Min in A1:A10
The total up to 40: =MIN(40/24,SUM(A1:A10)*24)
The excess over 40: =IF(SUM(A1:A10)*2440,MOD(SUM(A1:A10),40/24),"")
Both cells formatted with [h]:m
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"justnotgettingit" wrote in
message ...
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