Hey everyone, First off, I'm new to iReport, so please forgive me some nubish mistakes I might be making. I'm running iReport 2.0.0 In a report I use a query which looks as follows: Code: SELECT H.LocationNaam, H.ProjectCode, H.ProjectNaam, H.UursoortNaam, H.UserCode, H.UserANaam, H.UserVNaam, H.UserTV, MAX(H.`Week`) AS `Week`, SUM(H.Tijd) AS `Tijd Per Uursoort` FROM urs_bjorn.hcn_hours H GROUP BY H.LocationCode, H.ProjectCode, H.UursoortCode, H.UserCode ORDER BY H.LocationNaam, H.ProjectNaam, H.UursoortNaam, H.UserANaam, H.UserVNaam; Looking above in my query, you see I do a SUM on H.Tijd. H.Tijd is an integer which represents seconds. What I need to do, is convert these seconds to Hours:Minutes, having it as a Time format. The amount of hours will supersede the 23 (think of a max of over a 1000 hours) and I want the mintues only to go up to 59. Simply put, I want to see how much time was spent on a project. The amount of time that could be spent on a project could be something like 1013 hours and 23 minutes, looking like this: 1013:23. The value has to be a Timevalue and not a Stringvalue as it will be used to do calculations. Can anyone tell me how to go about this? Thanks in advance, Björn Post edited by: Scorpio78, at: 2007/07/25 12:48
