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
In your spreadsheet, multiply the duration value by 86400.
Format the result as a Number or use a custom number format.
Use a custom format
In Google Sheets, navigate to Format > Custom date and time > Elapsed seconds.
In Excel, open Format Cells > Number > Custom and enter [s].
Create your metrics using Metric Builder
Navigate to Metric Builder and select your Spreadsheet as the data source.
Create your Google Sheets metric and add it onto a Databoard.