Results 1 to 5 of 5

Automatic Formula for 1 column

Threaded View

  1. #1
    Registered User
    Join Date
    12-29-2008
    Location
    bronx
    MS-Off Ver
    Excel 2002
    Posts
    3

    Automatic Formula for 1 column

    I have two colums as shown below:
    Shift Time In
    Day

    The SHIFT column has the word DAY under it. The TIME IN column is empty.

    In the Shift column below if the value entered is "Day" I want the Time In column to say "1pm",
    If the value entered is "Night", I want the Time In column to say "7pm",

    I need a formula that will fill in the TIME IN column automatically based on whats on the SHIFT column. Please help me!

    Thanks!
    Last edited by nessadiaz; 12-29-2008 at 07:56 PM. Reason: solved

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