How to view and calculate difference between StartInterval and EndInterval columns


 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

  1. Select Columns S and T.
  2. Right-click on them, and select "Format Cells..." from the contextual menu.
  3. In the dialog that appears, select Date from the Category list on the left side.
  4. 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
  5. 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