Skip to Content
0
Jun 08, 2018 at 07:30 PM

Total Avg in Hours and Min

94 Views Last edit Jun 26, 2018 at 01:13 PM 2 rev

I have a report where I am getting the total minutes for a group of patients based on order date and transfer date using a formula called @TimeDiff: datediff("n",{Order_Proc.Order_Time},{Clarity_Adt.Effective_Time}), I then created another formula to sum up the minutes called @SumMin: sum({@TimeDiff}). I can get an AVG IN Minutes but I want an AVG in HOURS and MINUTES. So if I have 4 patients and the total minutes for these 4 patients is 255 minutes the avg in minutes is 63.75. How do I get that in Hours and Minutes ? Thanks.