How to convert minutes to Days:Hours:Minutes in Bold BI?

In Bold BI, you can convert a value in minutes to days, hours, and minutes using expressions. Here’s how to do it:

Steps

1. Create a calculated field for each unit (days, hours, and minutes) using the following expressions:

   • Days:

     FLOOR([Time taken]/1440)
     

   • Hours:

     FLOOR(MOD([Time taken],1440)/60)
     

   • Minutes:

     MOD([Time taken],60)
     

2. Bind these calculated fields to your widget.

3. The values will now be displayed in days, hours, and minutes format.

Example

Consider you have a field called Time taken that contains the time in minutes. You can create three calculated fields using the expressions mentioned above to display the time in days, hours, and minutes.

Using the above columns, you can display the date and time in the required format with the required separators in between.

Related Links

• Configuring Expression Columns