# Paketci Raporu ortalama teslimat süresi hakkında?

**URL:** <https://destek.sambapos.com/t/paketci-raporu-ortalama-teslimat-suresi-hakkinda/906>\
**Category:** Soru Cevap\
**Created:** [Nisan 24, 2019, 10:21öö UTC](https://destek.sambapos.com/t/paketci-raporu-ortalama-teslimat-suresi-hakkinda/906 "2019-04-24T10:21:37Z")\
**Posts on this page:** 1\
**Showing post:** 9

<div class="post-metadata">

**Author:** ![EmrBkts](https://destek.sambapos.com/user_avatar/destek.sambapos.com/emrbkts/32/1260_2.png) [@EmrBkts](https://destek.sambapos.com/u/EmrBkts)\
**Post date:** [Mayıs 6, 2019, 12:49ös UTC](https://destek.sambapos.com/t/paketci-raporu-ortalama-teslimat-suresi-hakkinda/906/9 "2019-05-06T12:49:01Z")

</div>

Merhaba,

Yukarıda bahsettiğim işlemi uygular ve aşağıda paylaştığım şekilde de rapor tanımlarsanız süre takibi yapabilirsiniz.

 ![image](https://destek.sambapos.com/uploads/default/original/2X/4/413293449d2d086924123028f84f83b7517cbc95.png)

`SELECT TicketNumber,Convert(time,LastPaymentDate,102) as OdemeSaat,Convert(time,Date,102) AcılısSaat,DATEDIFF(MINUTE,date,LastPaymentDate) as süre_DK FROM Tickets where Date>='{Start}' and Date<='{End}'`

 ![image](https://destek.sambapos.com/uploads/default/original/2X/4/494b6dee21b932dc0f8670471ad5a15609417319.png)

Rapor İçerik;  
[Paket Süre Takibi:1,1,1,1]  
\>\>Adisyon No|Ödeme Saat|Açılış Saat|Süre (Dk)  
@@Süre

 ![image](https://destek.sambapos.com/uploads/default/original/2X/a/af76f026d08da02c3facdfd02d54f9291c87e2fb.png)

---

_[View the full topic](https://destek.sambapos.com/t/paketci-raporu-ortalama-teslimat-suresi-hakkinda/906)._