How to create conversation log sheet?

Asked By Keith C Flick 0 points N/A Posted on - 03/28/2013

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.

• Status: Open
• Question Views: 1290
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Telecommunications

Best Answer by Jeremy J McPhail

Go To Solution

Best Answer

Best Answer

Answered By Jeremy J McPhail 50 points N/A #184123

How to create conversation log sheet?

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.

 

About Jeremy J McPhail

Questions
10

Answers
106

Best Answers
39

• Vote Up 0 Vote Down

• Posted on - 04/04/2013
• Question Category: Telecommunications

Answered By Robert B Guy 40 points N/A #184122

How to create conversation log sheet?

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

 

 

About Robert B Guy

Questions
16

Answers
101

Best Answers
25

• Vote Up 0 Vote Down

• Posted on - 06/16/2013
• Question Category: Telecommunications