• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Calculating hours in interval? [SOLVED]

mediatx

Member
Hi Guys


I am in Need to plan travel time as average based on an amount of days spending onsite at the customer.


In Detail: For every <=40 hours I Need write 4 hours in a separate cell.


So when someone spends 24 hours at the customer (less than a week) I want the fomula to write "4" into a cell.

If a Consultant spend 200 hours (5 weeks f work, base don 8 hours a day), I Need 40 (5x8) in that cell.


MAybe I just Need a break, but I dont find a solution for that.
 
Excellent! Thanks for that formula, it really does the Job and refreshed my brain... :)

Time to drop that §""!?% sheet for today.
 
Hi, mediatx!

Glad you solved it. Thanks for your feedback and welcome back whenever needed or wanted.

Regards!
 
Hi SirJB7,

Nice formula!


Not sure if the hours can be less than 1. If so, I would suggest a slight tweak as follows:

=MAX(4, INT((A2+39)/40)*4)


Cheers,

Sajan.
 
@Sajan

Hi, buddy!

Thanks for the compliment, but I assumed hours were integer as they are consulting hours from people who travel. But your tweak it's nice too, if I were the user I'd stick to it.

Regards!

PS: Have you noticed I'm following and emulating one of my gurus?
 
Hi All ,


As usual , the plain English description is not so plain and clear !



If a Consultant spends 200 hours (5 weeks of work, based on 8 hours a day), I Need 40 (5x8) in that cell.




Narayan
 
Hi Narayan,


Indeed! But I have seen you read minds before!! :)


On many occasions, when I had given up after reading a post thinking that no one could possibly understand what the poster is saying, I have seen you come up with the desired solutions! Learning from your approach, I have come to ignore portions of the posts so that I can interpret things the way I want!! :)


Regards,

Sajan.
 
Back
Top