How to format Duration data in Google Sheets?

Data formatted as Duration [hh]:[mm]:[ss] needs to be converted into seconds as Databox recognizes time durations only in seconds. Once converted, our system will then aggregate it back into minutes and hours depending on what format you choose on the Databoard.

The conversion can be done in two ways:

Use a conversion formula

  1. In your spreadsheet, multiply the duration value by 86400.

  2. Format the result as a Number or use a custom number format.


Use a custom format

  1. In Google Sheets, navigate to Format > Custom date and time > Elapsed seconds.

  2. In Excel, open Format Cells > Number > Custom and enter [s].

Create your metrics using Metric Builder

  1. Navigate to Metric Builder and select your Spreadsheet as the data source.

  2. Create your Google Sheets metric and add it onto a Databoard.