• 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.

Search results

  1. B

    Schedule formula

    9:00-2:15 9:00-2:16 9:00-2:17 9:00-2:18 9:00-2:19 Off Off 5.25 5.266666667 5.283333333 5.3 5.316666667 #VALUE! #VALUE! I want to type text in the cells when the employee is off on that particular day of the week. How do I have the formula omit "off", or count text as a "zero"?
  2. B

    Schedule formula

    Thank you to all of you for your help! This was absolutely what I was looking for. While each suggestion was helpful Narayank happened to fit what I needed. Thank you again to everyone who replied. I appreciate you taking the time to help me with my dilemma. If it's not too much I have one...
  3. B

    Schedule formula

    Thank you Hui! If you know of another way to make it calculate in the individual cell that would be my ideal situation since using multiple cells would be too large for what I'm trying to accomplish. Thank you again.
  4. B

    Schedule formula

    Hello Excel Masters, I have searched through the fantastic database we have here but I'm afraid my question may be so elementary that perhaps it hasn't been asked. I am creating a schedule for work and would like excel to calculate the length of a shift in a particular cell and deliver it...
Back
Top