In order to import phone call data into BringShare it must be in a specific format. In order for the data to be in the correct format, follow the steps below so the data can be correctly processed by BringShare.
To change the Date Column:
1. Highlight the column
2. In the "Number" drop down of Excel Toolbar select "Custom"
3. Then from the Categories choose "Date"
4. Select this format "3/14/2001"
To change the Phone Number:
1. Highlight the column
2. In the "Number" drop down of Excel Toolbar select "Custom"
3. Then from the Categories choose "Custom"again
4. You can overwrite or create your own new format
5. Enter in the format of "000-000-0000"
6. Click "Ok" and this will save as a new format option in your workbook for future use as well!
*Helpful link as well: http://office.microsoft.com/en-us/excel-help/create-or-delete-a-custom-number-format-HP005199500.aspx
To change the Duration:
1. In a separate row (I used the one to the right of Source) you will begin creating a formula for the duration change
2. To change the duration for times between 1-9 minutes use this formula ->
=CONCATENATE("00:0",C8,":00") (In place of C8, use the cell you would like to change)
3. Then pull this formula down to the remainder of the cells to have them use the same formula
4. From here, copy these cells with the formulated text
5. Highlight the column of cells in the duration column with original text
6. Right-Click and select "Paste Special"
7. From this menu, click "Values" under the section "Paste"
8. Click OK
9. For cells with 10+ minutes replace with this formula
=CONCATENATE("00:",C8,":00")
Comments
Please sign in to leave a comment.