I work at a call center and i've developed a spreadsheet to keep track on my calls. The information I have is ticket number, store number, who called, issue, if it was web or phone based call, resolution. I want to add 3 more fields. One would be start of call. The next would be end of call. The last would be the difference between the two.
What I need to do is have 2 buttons I can press that will insert the current time into the correct cell.
IE: I want cell a1 to be start of call. a2 end of call. a3 difference. Then start all over with b1, b2 ,b3, etc.
Does any of this make sense? I know there is a key combo to do this, but it needs to easy enough for a caveman to use.
Any help is greatly appreciated.
Thanks,
sgundrum
What I need to do is have 2 buttons I can press that will insert the current time into the correct cell.
IE: I want cell a1 to be start of call. a2 end of call. a3 difference. Then start all over with b1, b2 ,b3, etc.
Does any of this make sense? I know there is a key combo to do this, but it needs to easy enough for a caveman to use.
Any help is greatly appreciated.
Thanks,
sgundrum