How to show correct Hours and Minutes on Timesheet Summary Report
We have a timesheet table with hours column and minutes column by person and project and date. Each person will have multiple records, usually one for morning and another for afternoon.
The hours and minutes are calculated from a StartTime and EndTime and display nicely on the detail report.
The problem is that when using in the Summary report to get number of hours and minutes for each person for each project, the number of hours and minutes are totally, but the minutes might be 97, 122, etc. They are summarizing correctly numerically, but we really want to have minutes less than 60 and the number of hours increase correctly.
So, the 97 minutes would add 1 hour to the hours column and the minutes would decrease to 37.
Is there any way to accomplish this?
Thanks in advance for any suggestions.
Dean
The hours and minutes are calculated from a StartTime and EndTime and display nicely on the detail report.
The problem is that when using in the Summary report to get number of hours and minutes for each person for each project, the number of hours and minutes are totally, but the minutes might be 97, 122, etc. They are summarizing correctly numerically, but we really want to have minutes less than 60 and the number of hours increase correctly.
So, the 97 minutes would add 1 hour to the hours column and the minutes would decrease to 37.
Is there any way to accomplish this?
Thanks in advance for any suggestions.
Dean
