We have a 35 hour work week. I am trying to calculate the number of hours
between 35-40, then number of hours between 35-40 if over 40, and if under
35, then it shows 0. I can do it with 2 formulas on seperate lines then
doing an IF statement, but waswondering if it is possible to do it as 1
function.

Thanks.
--
Thank you!

=MEDIAN(0,A2-35,5) if you are working in hours,
or =MEDIAN(0,A2-35/24,5/24) if you are working in Excel times.
--
David Biddulph

"Nucera" wrote in message
...
We have a 35 hour work week. I am trying to calculate the number of hours
between 35-40, then number of hours between 35-40 if over 40, and if under
35, then it shows 0. I can do it with 2 formulas on seperate lines then
doing an IF statement, but waswondering if it is possible to do it as 1
function.

Thanks.
--
Thank you!

Try something like the following, with the number of hours in A1:

=IF(A1<35,"Less Than 35: "&A1,IF(A1<40,"Between 35 and 40:
"&A1,"Greater Than 40: "&A1))

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Sun, 26 Oct 2008 12:38:00 -0700, Nucera
wrote:

We have a 35 hour work week. I am trying to calculate the number of hours
between 35-40, then number of hours between 35-40 if over 40, and if under
35, then it shows 0. I can do it with 2 formulas on seperate lines then
doing an IF statement, but waswondering if it is possible to do it as 1
function.

Thanks.

Hi,

With the formula as stated you couldn't tell if 3 hours represented over 40
or between 35 and 40. So it sounds like what you need is

=IF(A140,A1-40&" hours over 40",IF(A135,A1-40&" hours over 35",0))


--
Thanks,
Shane Devenshire


"Nucera" wrote:

We have a 35 hour work week. I am trying to calculate the number of hours
between 35-40, then number of hours between 35-40 if over 40, and if under
35, then it shows 0. I can do it with 2 formulas on seperate lines then
doing an IF statement, but waswondering if it is possible to do it as 1
function.

Thanks.
--
Thank you!