Skip to main content

Hi all,

 

How do you display the sum of numbers as hours and minutes. e.g. sum is 90 so this should display as 1.30.

 

Thanks

Hi Anne

 

You can do this with an expression. I have attached a package with an example. Enter a number in the text box and it will convert it to a time value in the data label.

 

 

13015i40074BEBA7DA6602.png

Thank you, it worked :)

Hi Andrew,

 

I did the following, but when I put in 65 minutes, it comes with 1.50 instead of 1.05.

 

I have attached my expression below.

 

Thanks

 


11802iE03169B8F617BE85.png

Hi Anne

 

Try the following - this will pad the result of the modulo to 2 places.  I tried to use FormatNumber with D2 as the parameter but this doesn't seem to work.

 

12511iC4FE345EF50F4799.png

Thanks Andrew, that worked :)

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings