Error with time formula in hh:mm:ss format-hour must be between 0 and 23
I have a formula that adds the duration of phone calls for employees. and has a grand toal at the bottom of the report. I have built many report based off of this same formula, one for daily, one for weekly, and one for monthly for each employee. Everything works perfect until I run the monthly report. It will even work correctly as long as the grand total is less than 23 hours. Is there a way to allow the grand total in this format to have more than 23 in the hours?
One report goes to a department head which is in charge of say 4 sales people. In the monthly report he will receive a total for each sales person of total nuimber of calls and total talk time. The talk time totals for each rep are 16:23:45,10:07:14, 06:20:06, and 05:08:40. The grand total should be 47:09:45 for 47 hours, 9 minutes, and 45 seconds for the entire month. Can anyone h elp me resolve this issue?