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!![]()
Bookmarks