# Cohort query to determine sum of time elapsed between 2 date fields

**URL:** <https://talk.openmrs.org/t/cohort-query-to-determine-sum-of-time-elapsed-between-2-date-fields/37073>\
**Category:** Terminology\
**Created:** [July 11, 2022, 1:19pm UTC](https://talk.openmrs.org/t/cohort-query-to-determine-sum-of-time-elapsed-between-2-date-fields/37073 "2022-07-11T13:19:01Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![priyajoshi](https://talk.openmrs.org/letter_avatar/priyajoshi/32/5_5575768a8748004e209b776fc1b2916d.png) [@priyajoshi](https://talk.openmrs.org/u/priyajoshi)\
**Post date:** [July 11, 2022, 1:19pm UTC](https://talk.openmrs.org/t/cohort-query-to-determine-sum-of-time-elapsed-between-2-date-fields/37073/1 "2022-07-11T13:19:01Z")

</div>

Hi,

I want to create an indicator report to display average doctor turn around time for the visits created in the openmrs. The formula to determine doctor TAT is sum(timediff between date\_stopped & date\_created) for the visit divided by total number of visits in the openmrs. Can anyone guide me to achieve this indicator?

---

<div class="post-metadata">

**Author:** ![dkayiwa](https://talk.openmrs.org/user_avatar/talk.openmrs.org/dkayiwa/32/179_2.png) [@dkayiwa](https://talk.openmrs.org/u/dkayiwa)\
**Post date:** [July 28, 2022, 8:23pm UTC](https://talk.openmrs.org/t/cohort-query-to-determine-sum-of-time-elapsed-between-2-date-fields/37073/2 "2022-07-28T20:23:36Z")

</div>

> [@priyajoshi](#):
>
> divided by total number of visits in the openmrs

Don’t you want to group this by doctor/provider?