Hi,
I am creating a timesheet on excel currently.
The sheet consist of different cells,start finish,total hours etc, they are all fine.
I have a drop down menu as one of the cells, which consist of working day, annual leave and public holiday, what I am trying to figure out, is I need to link the drop down option with a certain hour when choosing it,so for example if I choose annual leave as an option on the drop menu in column C, I need the column for total hours column G to automatically change to show 07:12 but I dont how to do it, I know how to add a conditional format to colour code it but how to link a specific value to a drop down option.
Any help would be great.
Thanks
I am creating a timesheet on excel currently.
The sheet consist of different cells,start finish,total hours etc, they are all fine.
I have a drop down menu as one of the cells, which consist of working day, annual leave and public holiday, what I am trying to figure out, is I need to link the drop down option with a certain hour when choosing it,so for example if I choose annual leave as an option on the drop menu in column C, I need the column for total hours column G to automatically change to show 07:12 but I dont how to do it, I know how to add a conditional format to colour code it but how to link a specific value to a drop down option.
Any help would be great.
Thanks