Help. I have entered onto the Report Footer a calculation to add up all the estimated minutes on the report and convert them into HH:MM. Got close but it's off. For example: 360 minutes is being converted to 6 Hrs. 06 Min. This is the code I'm using:
="Total Estimated Time = " & Int(Sum([Est Time]/60)) & " Hrs. " & Format((Sum([Est Time]/60) Mod 60),"00") & " Min."
="Total Estimated Time = " & Int(Sum([Est Time]/60)) & " Hrs. " & Format((Sum([Est Time]/60) Mod 60),"00") & " Min."
