arnaldorafael Posted February 16, 2021 Share Posted February 16, 2021 Hi, guys thanks for time and help, i have a question i have field integer type whit seconds how i can convert this field to hours and minutes and sum the total in the column? Link to comment Share on other sites More sharing options...
Solution danoldenkampgmail.com Posted February 17, 2021 Solution Share Posted February 17, 2021 Keep it all in seconds so the summing works fine and then just change the formatting to hours / mins.String.format("%d:%02d:%02d", mySeconds/3600, (mySeconds%3600)/60, (mySeconds%60)) From:https://community.jaspersoft.com/questions/800934/seconds-time Link to comment Share on other sites More sharing options...
arnaldorafael Posted February 18, 2021 Author Share Posted February 18, 2021 Thanks Link to comment Share on other sites More sharing options...
arnaldorafael Posted February 18, 2021 Author Share Posted February 18, 2021 HI, one more question i have a Subtotal Time Sum but por example i get the next value221:14:2796442how i can round the second from 00-99 and get a value of 221:14:28, thanks Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now