cchristner
10-18-2016, 10:28 PM
Hey guys,
I was wondering if there is a code that will automatically determine what the current shift is and fill that information in a cell in excel? So third shift starts at 10PM, First shift Starts at 6AM and second shift starts at 2PM. We have a log book that gets filled out once per shift. Is there anyway to have it automatically know what shift is working based on the actual time and put the shift in cell G1 in the excel workbook?
I was wondering if there is a code that will automatically determine what the current shift is and fill that information in a cell in excel? So third shift starts at 10PM, First shift Starts at 6AM and second shift starts at 2PM. We have a log book that gets filled out once per shift. Is there anyway to have it automatically know what shift is working based on the actual time and put the shift in cell G1 in the excel workbook?