Skip to Content
Jun 12, 2019 at 05:45 PM

Avg of DateDiff Formula

90 Views Last edit Jul 22, 2019 at 02:51 PM 2 rev

I created a formula to get the minutes between 2 times using DateDiff:


This formula is displaying the correct amount in minutes for each patient but my average is way off. In the example below I have 4 patients where the average should be 64.25 but my report says 40.19. I am using a summary to get the average of the DateDiff field. Not sure why it is not giving me the correct average.


rdlhu.png (9.5 kB)