How to calculate Average Minimum Time ?

[aungkyawnyein]

Hello,

Here is my problem, I have a table as follow:

Sale Man	Date	Time
A	10.8.18	8:10 AM
A	11.8.18	8:25 AM
A	12.8.18	8:11 AM
B	10.8.18	9:11 AM
B	11.8.18	8:21 AM
B	12.8.18	8:17 AM
C	10.8.18	8:41 AM
C	11.8.18	8:33 AM
C	12.8.18	8:19 AM

I need to calculate in KPI Chart: the Average Minimum time for a day or Average Minimum time for Salesman.

My expected outcome is like below:

• Avg min time for 10.8.18 = 8:40 AM
• Avg Min time for sale man A = 8:15 AM