Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
Licensing, Cloud and Web Services
  • Welcome to Bentley Communities
  • Bentley's Communities
  • Licensing, Cloud and Web Services
  • Cancel
Licensing, Cloud and Web Services
Licensing, Cloud and Web Services Wiki How to view and calculate difference between StartInterval and EndInterval columns
    • Sign In
    • Contacting Entitlements Support (Licensing and User Management)
    • Eastern Europe Continuity Plan
    • Guest Accounts - Review Access
    • -Web Services
      • +CONNECT Center
      • -Subscription Services Portal
        • +Subscription Services Portal Overview
        • +User Management 2.0
        • +Entitlement Management
        • +Roles and Permissions (Role-Based Access Control or RBAC)
        • +Software Downloads
        • -Subscription Analytics
          • Subscription Analytics (Usage Reporting)
          • +Accessing the Usage and Analytics Reports
          • Earned Value Discount
          • Daily Peak Application Usage
          • Daily Usage by Machine
          • Daily Usage by User
          • Version Adoption
          • Usage Details
          • Visa Consumption
          • CONNECTION Client Inventory
          • E365 Usage
          • Alert History
          • Activation Key Audit
          • Cloud Service Usage
          • Term License Consumption Report
          • Pricebook Report
          • Product Rollup Report
          • ProjectWise Usage Report
          • Real time Application Usage
          • +Activation Key Mappings
          • -Analytics Data Export
            • How to view and calculate difference between StartInterval and EndInterval columns
            • Scriptable Exports
          • Entitlement Exceptions
          • What's New? Subscription Analytics
          • Frequently Asked Questions
          • Allocation groups and how to use them
          • Subscription Analytics Reports - German Users
        • Software Administration
        • +Virtualized Environments
        • Enterprise License Subscription (ELS) Eligibility List
      • +Bentley Cloud Services Overview
      • Account Status: ON HOLD
      • How to check the status of Bentley Cloud Services
      • ServiceNow Login Issue
      • We didn't recognize the email address or password you entered
    • +SES Activation
    • +CONNECTION Client
    • +CONNECT Advisor
    • +Federated Identity
    • +SELECTserver based Activation
    • +Pre-SELECTserver Based Activation
    • +Product-Specific Licensing
    • Understanding why you received a TL Invoice
    • Working from Home using Bentley Licensing
    • What you need to know/request when consolidating Accounts
    • +Licensing Workflow
    • How to leave a Product Review
    • +Serviços ProjectWise 365
    • About Bentley Trust Licensing
    • Customer Number, Account Number, Entitlements, Users
    • Support for non-Bentley technologies utilized by Bentley products
    • Support for V8i applications after December 31st, 2021
    • +Support Homepage - Localized

    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

    • usage calculation
    • reports
    • en
    • SELECTsupport
    • Share
    • History
    • More
    • Cancel
    • jeremyhoesly Created by Bentley Colleague jeremyhoesly
    • When: Thu, Apr 8 2021 5:10 PM
    • jeremyhoesly Last revision by Bentley Colleague jeremyhoesly
    • When: Thu, Apr 8 2021 5:11 PM
    • Revisions: 2
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies