+ Reply to Thread
Results 1 to 5 of 5

How to set up a time Sheet on Excel to restrict entry to only allow 5 workdays instead 7

Hybrid View

  1. #1
    Registered User
    Join Date
    10-22-2014
    Location
    athens, ga
    MS-Off Ver
    2010
    Posts
    3

    How to set up a time Sheet on Excel to restrict entry to only allow 5 workdays instead 7

    I am setting up a time sheet for my employers to use. There are 7 days in a week but I want to set it up in such a way that the user can only input work hours for 5 days a week and prohibit them from inputting anything on the other 2 days. For example, if Employee A worked Mon-Fri, then the user (employer) can enter the work hours for Mon-Fri but are not able to enter work hours for Sat and Sun. I want those cells to be inactive/prohibited.

    Is there a formula where if ANY 5 cells are active, the other 2 will be inactive/prohibited?

  2. #2
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    452

    Re: How to set up a time Sheet on Excel to restrict entry to only allow 5 workdays instead

    Does formatting Monday thru Friday's cells as unlocked, then protecting the sheet (through the review tab) and not allowing selecting of locked cells work for you?

  3. #3
    Registered User
    Join Date
    10-22-2014
    Location
    athens, ga
    MS-Off Ver
    2010
    Posts
    3

    Re: How to set up a time Sheet on Excel to restrict entry to only allow 5 workdays instead

    No, I am not allowed to do that. Actually, I thought about using =COUNTA function but my data validation isn't working on my worksheet. I think it's because I'm using the time format when I enter values into the cell? Do you know anything about this?

  4. #4
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    452

    Re: How to set up a time Sheet on Excel to restrict entry to only allow 5 workdays instead

    COUNTA would still count a time format. I am out of ideas on this.

  5. #5
    Registered User
    Join Date
    10-22-2014
    Location
    athens, ga
    MS-Off Ver
    2010
    Posts
    3

    Re: How to set up a time Sheet on Excel to restrict entry to only allow 5 workdays instead

    Can you figure out why this is not working? Why I am able to allow to input values totaling over 60?

    URL of photo http://postimg.org/image/py9rmfbq7/
    Attached Images Attached Images
    Last edited by opera6th; 10-22-2014 at 10:25 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Copy a specific range to another sheet adding all the workdays for a specific time period
    By MariaPap in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-05-2014, 02:19 AM
  2. EXCEL: Restrict Invalid Entry On Cell Having Data Validation
    By gaikwad.mm@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-12-2013, 03:27 AM
  3. Restrict cell entry
    By LeePrice in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 12-05-2012, 07:29 AM
  4. Replies: 0
    Last Post: 11-06-2012, 04:09 PM
  5. Replies: 0
    Last Post: 09-10-2012, 04:51 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1