Velocity Telephone

Virtual Office
Residential VoIP
Troubleshooting
Telephone Features
Conversion FAQs
Install/Move Fees

Format the date/time fields in Excel for exported call logs?

Excel requires a custom date/time format be entered in order to display a full date and time down to the seconds. Excel does not have a standard format that includes the full date and time down to the second, only down to the minute.

Excel provides the ability to display the full date and time using the custom format feature. The format to display the full date and time can be entered manually for a column, and the Format Paste feature used to apply the format to each of the date/time columns.

To format a date/time column to display the full date and time down to the seconds:

Open the CSV file in Excel

Click the column header of the first date/time column

Right click the column header and select "Format Cells..."

Select the "Number" tab

Select "Custom" from the category list

In the "Type" field enter "m/d/yyyy hh:mm:ss AM/PM"

Click "OK"

To apply the format to the remaining columns:

Select the column showing the date/time format just entered
Click the format painter icon (the paint brush icon)
Click on the column header for the next date/time column that needs the full date/time formatting

Repeat this process for each additional column that requires the full date/time displayed down to the seconds.

Did this Frequently Asked Question provide the information you were looking for? Provide us with your Feedback and suggestions for improving this FAQ.