Very Basic Excel yes / no formula required

  • Status: Closed
  • Prize: £10
  • Entries Received: 33
  • Winner: manaf9387

Contest Brief

Hi there

We have many timesheets (one pasted below) and we would like a formula which can quickly help us work out the following to be marked YES or NO next to each row:
1) if the day is Saturday or Sunday - mark YES
2) if the day is not Saturday or Sunday but the END TIME is before and including 09:00 - mark YES
3) if the day is not Saturday or Sunday but the START TIME is after and including 17:00 - mark YES
4) if the day is not Saturday or Sunday but the START TIME is on or after 09:00 AND the END TIME is on or before 17:00 - mark as NO

Day -------------- Start ---- End ------------- YES/ NO
Wednesday 06:35 07:35 YES
Wednesday 07:45 08:15 YES
Wednesday 08:20 08:50 YES
Thursday 20:15 20:45
Thursday 21:00 21:30
Friday 21:35 22:05
Tuesday 10:55 11:25 NO
Tuesday 11:30 12:00 NO
Tuesday 12:15 13:00 NO
Tuesday 13:05 14:05
Friday 07:05 07:50
Friday 07:30 08:15
Friday 07:55 08:55
Friday 09:10 09:40
Saturday 16:05 16:35
Saturday 17:25 17:55
Friday 16:40 17:10
Friday 17:25 17:55
Friday 18:25 18:55
Friday 19:25 19:55
Friday 20:15 20:45
Friday 21:00 21:30
Saturday 09:15 10:15
Saturday 10:25 11:25

Recommended Skills

Top entries from this contest

View More Entries

Public Clarification Board

  • espanajv
    espanajv
    • 2 years ago

    ?

    • 2 years ago
  • espanajv
    espanajv
    • 2 years ago

    Do you have any time to send you my code

    • 2 years ago
  • arsalan1176
    arsalan1176
    • 2 years ago

    Congratulations!

    • 2 years ago
  • uksikh
    Contest Holder
    • 2 years ago

    for the time slots which are: not on Saturday and Sunday and start before 9am and finish after 9am OR start before 17:00 but finish after 17:00, instead YES or NO, can you show "STRADDLE". For example, look at row 18

    • 2 years ago
    1. MimiFL
      MimiFL
      • 2 years ago

      I've included this case, before others. Please take a look at entry #39 .

      • 2 years ago
  • saurabh1985vw
    saurabh1985vw
    • 2 years ago

    FOR YOUR ACTUAL REQUIREMENT

    • 2 years ago
  • saurabh1985vw
    saurabh1985vw
    • 2 years ago

    CAN WE CHAT

    • 2 years ago
  • saurabh1985vw
    saurabh1985vw
    • 2 years ago

    ARE YOU ONLINE

    • 2 years ago
  • saurabh1985vw
    saurabh1985vw
    • 2 years ago

    CAN SHOW

    • 2 years ago
  • Madurawala1
    Madurawala1
    • 2 years ago

    Kindly Contact me for the Excel Sheet.
    Thanks!

    • 2 years ago
  • mickanona2013
    mickanona2013
    • 2 years ago

    #18 and #19 Png files please

    • 2 years ago
  • allanderson1128
    allanderson1128
    • 2 years ago

    Contact me for the sheet and translation, also please send back any problems even if I do not win. Thank you.

    • 2 years ago
  • ghous01
    ghous01
    • 2 years ago

    Kindly Contact me for the Excel Sheet.
    Thanks!

    • 2 years ago
  • eDATAEXPERT
    eDATAEXPERT
    • 2 years ago

    Contact me for original file, please

    • 2 years ago
  • mariusalex86
    mariusalex86
    • 2 years ago

    Kindly contact me for the Excel sheet.

    • 2 years ago
  • saurabh1985vw
    saurabh1985vw
    • 2 years ago

    For Formula please contact me

    • 2 years ago
  • saurabh1985vw
    saurabh1985vw
    • 2 years ago

    Day Start End YES/no
    Wednesday 06:35 07:35:00 Yes
    Wednesday 07:45 08:15:00 Yes
    Wednesday 08:20 08:50:00 Yes
    Thursday 20:15 20:45:00 Yes
    Thursday 21:00 21:30:00 Yes
    Friday 21:35 22:05:00 Yes
    Tuesday 10:55 11:25:00 No
    Tuesday 11:30 12:00:00 No
    Tuesday 12:15 13:00:00 No
    Tuesday 13:05 14:05:00 No
    Friday 07:05 07:50:00 Yes
    Friday 07:30 08:15:00 Yes
    Friday 07:55 08:55:00 Yes
    Friday 09:10 09:40:00 No
    Saturday 16:05 16:35:00 Yes
    Saturday 17:25 17:55:00 Yes
    Friday 16:40 17:10:00 No
    Friday 17:25 17:55:00 Yes
    Friday 18:25 18:55:00 Yes
    Friday 19:25 19:55:00 Yes
    Friday 20:15 20:45:00 Yes
    Friday 21:00 21:30:00 Yes
    Saturday 09:15 10:15:00 Yes
    Saturday 10:25 11:25:00 Yes
    Sunday 10:25 11:25:00 Yes

    • 2 years ago
  • saurabh1985vw
    saurabh1985vw
    • 2 years ago

    Yes
    Yes
    Yes
    Yes
    Yes
    Yes
    No
    No
    No
    No
    Yes
    Yes
    Yes
    No
    Yes
    Yes
    No
    Yes
    Yes
    Yes
    Yes
    Yes
    Yes
    Yes

    • 2 years ago
  • saurabh1985vw
    saurabh1985vw
    • 2 years ago

    Here I am Posting my Answer for your List

    • 2 years ago
  • saurabh1985vw
    saurabh1985vw
    • 2 years ago

    Yes I did completed your query and created a formula.

    • 2 years ago

Show more comments

How to get started with contests

  • Post your contest

    Post Your Contest Quick and easy

  • Get tons of entries

    Get Tons of Entries From around the world

  • Award the best entry

    Award the best entry Download the files - Easy!

Post a Contest Now or Join us Today!