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

    Need to restrict cell entry to date and time in excel 2010

    Adding the 2 cells worked perfectly without having to adjust that long formula :-)
  2. O

    Need to restrict cell entry to date and time in excel 2010

    I think I it does actually calculate hours.
  3. O

    Need to restrict cell entry to date and time in excel 2010

    Great answer! As far as the formula goes, I thought at the time I did this that I had found a way to acount for working hours. And I thought I even tested it. But it's long enough ago that I'll have to test again.
  4. O

    Need to restrict cell entry to date and time in excel 2010

    I agree that it would be the easiest way to handle it. However, I use this input with the formula below. The networkdays function uses date and time in a single cell. So it's more important to me to have the data in a single cell than to have validated separate cells. I thought about maybe...
  5. O

    Need to restrict cell entry to date and time in excel 2010

    Hi, I'm doing duration computations that require cell input in the (mm/dd/yyyy hh:mm) format. I know I can use data validation to require a date or a time to be entered, but I can't figure out if there is a way to insure that date and time are entered. Does anyone have any suggestions...
Back
Top