I was unable to get the posted workbook, but here's a possible solution.

Column A Column B
Column C
Total Hours Regular Hours Overtime Hours
45.6 =IF(A240,40,A2) =IF(A240,A2-40,0)

--
Kevin Backmann


"ryevick" wrote:


(This is for a time card) I need to add positive and negative numbers in
a column... if the value is over 40 I want to display 40 and place the
balance in the cell below as overtime hours... if it is under 40 just
display it and nothing below... What is the formula(s)/function(s) for
this... Please help (pt. 1) Thanx


+-------------------------------------------------------------------+
|Filename: Time_Card.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4040 |
+-------------------------------------------------------------------+

--
ryevick
------------------------------------------------------------------------
ryevick's Profile: http://www.excelforum.com/member.php...o&userid=28882
View this thread: http://www.excelforum.com/showthread...hreadid=486316