Jump to content
We've recently updated our Privacy Statement, available here ×

expression to convert digital hours and minutes to a string


phillip.howcroft

Recommended Posts

I want to take a decimal which has been summed in by a variable to XXX.xx and convert it to YYY:yy where the yy is mins 

I can do this in SQL using

 TRUNC(Summary.Actual_Hrs) || ':' || SUBSTR (('00' || TRUNC(((Summary.Actual_Hrs) - TRUNC(Summary.Actual_Hrs))*60)), -2) AS Actual_Hrs

but i dont know how to do this in jaspersoft studio (5.6) using expressions. I've  trawled here and Google but it only gives references to time in dates not a summing of hours and minutes.  Can anyone point me in the right direction

Thanks

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...