Forum Discussion
Email Response time from Outlook Exchange
Hello Anonymous
exactly, I choose the duration in minutues. 1140 minutes are 19 hours. You can change this also to hours. Just replace the Duration.TotalsMinutes to Duration.TotalHours. If you remove this function completely you will get a duration-value like 0.19:00:00
For sure you have to remove my resource steps with your query. This is only to show how to get the result. This kind of transformation you have to dig in the M-code :). If you are not able to apply my code, you can post your query here, then I can do it for you. But be aware that my solution works with your data provided. If your data is different, it may not work and we need to adapt it even more.
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
Hi Jimmy801 , I hope you can answer this question. I am working with an outlook database, and to know the days elapsed since an email with a case to be resolved is received until its resolution, but I would not know how to put together the formula (I have the dates of sent and received), since there would be many mails (different cases per client) I thought of doing it by subject: when it starts, put region_customername_test1 and when region_customername_resolved_test1 is resolved. Would you have any suggestion? Is this possible to do? Thank you in advance