Results 1 to 7 of 7

Indicate shift type coresponding to the time of day in a cell...

Threaded View

  1. #1
    Registered User
    Join Date
    01-02-2012
    Location
    Winnipeg, Canada
    MS-Off Ver
    Excel 2010
    Posts
    3

    Indicate shift type coresponding to the time of day in a cell...

    I have 3 possible shifts: Day, Evening & Night.
    Days are 7:45-16:00, Evenings are 15:45-24:00 and Nights are 23:45-8:00.
    I want a formula that will tell me what shift an employee works based on the start time.

    eg.
    D3=7:45 AM, F3=4:00 PM (this is a day shift)
    D4=3:45 PM, F4=12:00 AM (this is an evening shift)
    D5=11:45 PM, F5=8:00 AM (this is a night shift)

    How can I get Cell I3 to display the word "Day" or "Evening" or "Night" properly?

    I have attached a sample sheet.

    thanks.
    Attached Files Attached Files
    Last edited by Alwpg; 01-02-2012 at 07:28 AM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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