I am quite a novice at excel an I am looking for some help. I have an employment rota which my colleagues enter in their hours for their working week and it calculates the time worked for the week.
I am trying to allow the system to automatically assign a set time when the word "HOLS" (for holiday) is typed. I want it to assign the value 07:15.
Is it possible to assign a rule that says; IF the cell below ="HOLS" Then this cell should read "07:15"
Regards
John
Aucun commentaire:
Enregistrer un commentaire