Hi all ,
I am a newbie to this forum , so excuse me if im a posting this to the wrong forum
I have a simple requirement.
I have this timesheet at work where i need to compute the time each employee spent on a specific task.
So that said i have only 5 colums in my excel :name of employee, task, starting time ,ending time and duration.
I can do the subtraction manually to obtain the duration, for example =D1-C1 , this is excessively time consuming. I would like to automate this. whereby when the employee input the starting and ending time, excel automatically calculates that for me. is this possible??
thanks in advance
BTW : am not an excel expert