Hi
Please find attached a file for your reference. Basically, the maximum hour is 8 in column C regardless the difference between col A and B. How can i achieve it?
Thanks
Last edited by Harrold; 01-27-2012 at 03:29 AM.
Hi,
a possibility:
Regards=MIN(8/24,B1-A1)
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon below the post.
Please, mark your thread [SOLVED] if you received your answer.
Forum rules: http://www.excelforum.com/forum-rule...rum-rules.html
please look at attachment
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
=min(b1-a1,1/3)
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Does this do what you are after?
Edit: Forget mine, it does not work.=MAX(IF((B3-A3)>=8,8*24,B3-A3),8)/24
Last edited by JapanDave; 01-27-2012 at 03:34 AM.
If you are happy with the answer, please click the Star icon in the below left hand corner.
Good sites to start learning.
snb's VBA Help Files
Jerry Beaucaires Excel Assistant
J & R Excel Consultancy Services
How to post code correctly: Correct Code Posting
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks