I running a small business I need conversation log sheet to create for all outgoing and incoming calls. Can anyone help me figure it? Which is required to do that please tell me with details. Please help Mr. Exparts from all around the world.
Hello, Keith C Flick
Hope you are fine.
In Excel, put the data given below in Row 1, from columns A into E:
Name
Subject
Call Start
Call End
Duration.
Selecting cells C2 into E2 now right-click  > "Format" >"Cells," and make sure the cells have the 24 hour date format because it is standard but is not mandatory.
Now click on the Data tab in Excel 2007 > "Data Validation."
Select "Time" from drop- down menu, keep it at "between," Â
Select a starting time of 00:00, and an ending time of 23:59.
Now put the formula in cell E2: "=MOD (D2-C2, 1)." It determines the duration of the call.
The =MOD () function specifies the starting call before midnight and ending calls after midnight to give the correct duration.
Hope you will get your answer.
Â
Thank you for your query.
I am giving you a sample file which you can use as a log record file.
Here you find all possible boxes to record the necessary data.
For further query feel free to ask question Filesnack.
Have a nice day
Â
Â
