Results 1 to 2 of 2

Excel 2007 : "IF" Conditioning

Threaded View

  1. #1
    Registered User
    Join Date
    07-14-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    2

    "IF" Conditioning

    Hi guys, I need help with solving this problem for my company.

    Currently, I have 3 stardard working time for total of 14 staff

    Start Time Lunch Logout Time Lunch LoginTime End Time
    9.00AM 1.00PM 2:00 PM 7.00PM
    9:00AM 2:00PM 3:00 PM 7:00PM
    12:00PM 4:00PM 5:00 PM 9:00PM

    I would like to have 5th columns with the results " either "Puntual" otherwise "Tardines"

    Eg.
    Staff works on 9am with lunch at 1pm and ends 7pm.
    if the start time is later than 9:15am or 12:14:ppm and no lunch logoutlogin time and end time is earlier then 7"pm/earlier 9pm, the result should be tardiness otherwise punctual

    await your reply
    Last edited by romperstomper; 07-14-2011 at 12:04 PM.

Thread Information

Users Browsing this Thread

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

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