Hi,
In Cell A1 I have the date. In Cell B1 is the shift. There are three shifts labeled as 1, 2, and 3. Is it possible to create a rule that will convert 1 to 0700, 2 to 1500, and 3 to 2300? Below is an example of how I need the shifts converted to time (military).
Current Format Needed Format
Date Shift Date Time
4/15/2014 1 4/15/2014 7:00
4/16/2014 3 4/16/2014 23:00
4/17/2014 2 4/17/2014 15:00
4/18/2014 1 4/18/2014 7:00
4/19/2014 1 4/19/2014 7:00
4/20/2014 2 4/20/2014 15:00
4/21/2014 3 4/21/2014 23:00
Bookmarks