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

    Adding hours to date

    @Hui, thanks for the update. The date format is OK and working as expeceted. Leaves the question open on how to add hours to a date and calculating the new date/time in other cell considereing working hours. :(
  2. M

    Adding hours to date

    @oldchippy Just went through it, and it looks right at the first place but actually its the enddate and time I want to calculate and I dont get networkdate to work without the enddate provided in the formula. Is my mind still blocked?
  3. M

    Adding hours to date

    @Huy: I am located in europegermany and thats our date format, does Excel require the format you mention always or is that more a US thing?
  4. M

    Conditional Formatting for dummies please?

    took me some time to get it working! Thanks so much!
  5. M

    Adding hours to date

    Hi everyone, I searched, tried and failed, a hundred times, several hours now... Am I that blind? I have a service schedule from (C2)09:00 - (D2)17:00 A taskplan starting with a Startdate in A9 entered as 29.04.2010 09:00:00 Cell A10 needs to be the Enddate, calculated based on a value...
  6. M

    Conditional Formatting for dummies please?

    Hi Champs I might be completely blind after working days on the same sheet to create an assessment solution based on excel. Now coming to the "optical" part, I dont find a way to color text in sheet2!B2 based on a value in sheet1!C2 (Yes, No, Partially). If Sheet1!C2 is Yes, then i want...
View older results
Back
Top