| Product(s): | Subscription Analytics | |
| Area: | Data Export | |
This wiki shows how to view the StartInterval and EndInterval columns and calculate the difference between them.
Background
The Intervals Data export in Data Export provides useful data, but when opened in Excel, it does not display dates and timestamps by default. It also lacks a difference column to quickly identify the duration of usage.
Steps to Accomplish
Format the StartInterval and EndInterval columns to display properly
- Select Columns S and T.
- Right-click on them, and select "Format Cells..." from the contextual menu.
- In the dialog that appears, select Date from the Category list on the left side.
- In the Type list on the right side scroll down, and select the listing with both a date and time stamp in either the 12-hour or 24-hour format.
![Screenshot of Format Cells dialog](d08077ea97f18e10afb952800153afbd.iix)
- Click OK to save changes.
Calculate the difference in minutes between the StartInterval and EndInterval column
Adapt the following formula which provides the difference in minutes:
=(T2 - S2) * 1440