Even though we set the max_unit=hours, for Line type reports using the Business Elapsed Time, this works.

This problem is that anytime the report type is changed to Bar, and an Aggregation = Average, the Aggregate field is Business elapsed time, the OOB default format changes back to DD/HH/MM/SS time format. 

I am reading that we can create a new Duration field in the Task_SLA table, call it Business Elapsed Hours (BEH), however it contains no records. One has to code either a Business Rule, or scheduled job that will fire at certain times of the day to copy the value from Business Elapsed Time (BET) to Business Elapsed Hours (BEH), but should only happen if BEH is null. 

BET can also be used to track Incidents responding, and Incidents Resolved. This is done using SLA Definitions. 

1. So what mechanisms should we use to trigger the Business Elapsed Hour field to get filled?

2. Can I format the Business Elapsed Hour field to used both HH:MM:SS?

thanks