Pull the All Melds Report. Click on the icon in the upper right-hand corner and select Reports from the drop-down menu.
Click on the All Melds report title. Fill in the desired Creation Start Date, Creation End Date, and select the desired property group (optional), then click Generate Report.
Note: If you’d like the report for all time, you can leave the start and end date fields blank.
Locate the email and download the report and open it up.
In excel, click on column Q (area highlighted below) to select the whole column.
Click on the Sort & Filter option on the Home tab, the select Filter from the drop-down. This will make a drop-down appear on column Q.
Click the drop-down button in column Q and uncheck the Blanks checkbox, then click OK. This will filter out any Melds that have not been completed.
Scroll to the last column on the right-hand side and create a new column titled Completion Time.
Now, you will enter the function that will subtract the values in column F (Creation Date) from those in column Q (Completion Date) to find the completion duration. Here’s how:
(Steps are displayed in this video as well: Steps a-g)
a. click in the first row underneath the Completion Time header you created
b. type an = sign
c. scroll over and click the first row in column Q
d. Type a - sign
e. scroll over and click the first row in column F
f. press enter
g. click and drag the Completion Time column to the bottom of your data set