I am trying to use a custom expression to sum the hours a person worked on a certain day (e.g., 2.5 hrs) and to calculate and display what time it would be that amount of time after 8:00am on that day (e.g., 8:00am + 2.5 hrs = "10:30," so "10:30" should be displayed in this example).
I do this by using the following formula:
aggregator.displayformat=HTML
aggregator.function=SUM
aggregator.valueexpression=IF({hours} = 0,"-",CONCAT(HOUR(ADDDAYS(DATE("1/1/00"),(8+{hours})/24)),":",RIGHT(CONCAT("0",MINUTE(ADDDAYS(DATE("1/1/00"),(8+{hours})/24))),2)))
aggregator.valueformat=HTML
displayname=End Time
querysort=hours
shortview=true
textmode=true
valueexpression=IF({hours} = 0,"-",CONCAT(HOUR(ADDDAYS(DATE("1/1/00"),(8+{hours})/24)),":",RIGHT(CONCAT("0",MINUTE(ADDDAYS(DATE("1/1/00"),(8+{hours})/24))),2)))valueformat=HTML
However, the aggregate in the groupings is only displaying the sum of the hours (e.g., "10" following the example above), but it is not displaying the full concatenation. I can get the tasks to display the time (e.g., "10:30") accurately, but it is not displaying properly in the aggregate, which is where I really need it.
Any thoughts?
