Minutes function
Applies to: TBM Studio 12.0 and later
Converts a specified date to a decimal value, which can be used in formulas. The decimal value is the number of minutes since January 1, 1970.
Where to use
- Data sets
- Calculated metrics and reports with metric columns
- Formula columns in report tables
- Dynamic text
Syntax
Minutes(date_expression)
Arguments
date_expression
An expression that evaluates to a date to be converted to a double value. The format is MM/DD/YYYY HH:MM or any other standard date format supported by the application.
Return type
Number
Example
Assume you want to calculate the duration of support calls. You have a data set with two columns: SupportTicket_Start and SupportTicket_End. The data in the columns is in the format MMDDYYYY HH:MM. You define a third column in the table to calculate the length of each call. The formula for the third column is:
=(Minutes({SupportTicket_End}))-(Minutes({SupportTicket_Start}))
The result is shown below:
