Need Help With Excel Formula

  • Thread starter Thread starter jlhw
  • Start date Start date
J

jlhw

I'm trying to write a expression to show working hours.
In column D I need to have Regular Hours which equal 40. In column C
have actual Hrs worked. I need an expression to show column D. that i
it is 40 show 40, but if not show what the actual hrs where. I'll giv
an example of what I mean

cell C4 = 42
I need an expression so that Cell D4 will show 40 hr.
And in cell E4 I need a expression to show the 2 overtime hrs.

Thanks so much for the help!!

attached is a sample file to show better what i mea

Attachment filename: book1.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=47936
 
Hi
try the following:
D4: =MIN(C4,40/24)
E4: =MAX(C4-40/24,0)
format both cells as time
 
D4: =MIN(40,C4)
E4: =MAX(0,C4-D4)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top