1. Home
  2. Forum
  3. Dashboard Platform
  4. Expression Designe to convert Minutes values

Expression Designe to convert Minutes values

hi,

i want to write down an expression in dashboard designer, to transform a numerical value representing minutes to HH:MM

Example :

make 130 looks like : 2 hours and 10 minutes

1 Reply
AR Anandaraj Radhakrishnan Syncfusion Team June 20, 2018 12:06 PM UTC

Hi Zoe,   
  
Thanks for contacting Syncfusion support.   
  
Your requirement can be achieved by creating the expressions as shown below.  
  
ExpHours  = Cast([Duration] as int) / 60   
ExpMinutes = Cast([Duration] as int) % 60   
Time = CONCAT([ExpHours], ' hours and ', [ExpMinutes], ' minutes')   
  
Sample output in grid control.   
    
We have also attached the demo video for creating these expressions.   
  
Regards,   
Anandaraj R  

Loader.
Up arrow icon