Hello I have various shifts, I have a spread sheet which is CSV ready for google and outlook calendar ready, to save time I wish to automate some of the stuff i.e. dependant on what is inputted in Cell A** (about four five variables ET, LT, NT, AL, RD) I want cells C D E completed accordingly.
ET Early shift 8 Hours so C - 07:00 D Date of Fin E time of finish in this case 15:00
LT Late Shift 9 Hours so C - 14:00 D Date of Fin E time of fin in this case 23:00
NT Night Shift 9 Hours so C - 22:00 D Date of fin in this case following days date, E time of finish in this case 07:00 following day
RD Rest day no value leave blank count nothing
AL Annual leave no value leave blank count nothing
I have tried to attach an image but not sure if its been successful, happy to send image of screen shot
I have tried IF TIME etc statement not getting anywhere
But can anyone help ?
thanks