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

    Shiftless Worksheet - fill shift cell based on time cell

    Thank you very much Swaroop; it is indeed ugly - but it works.
  2. J

    Shiftless Worksheet - fill shift cell based on time cell

    This is the formula I tried: =IF(AND(C832<=17:00,C832>=7:01),"1","3")
  3. J

    Shiftless Worksheet - fill shift cell based on time cell

    I have created a spreadsheet for collecting data across all two work shifts at my company. The workers enter the date and time into two columns and their shift (1 or 3)in another column. I would like to fill the "shift" field based on input in "time" field. The time field is formatted hh:mm...
Back
Top