Hi,

 I need to make a report like this

it is a report to monitor how much time it takes for our sales representatives to follow up by chat or call after they are given a lead.

we create two Date/Time fields called 'Start Time - Sales Qualified Lead' and 'Exit Time - Sales Qualified Lead' to record when the events happened.

but now I have two problems:

1. I can't calculate time difference (as minutes) between these two fields.

and eventually we also need the summary report like this

2. this is my second problem, I need to aggregate data (Average, Max, Min) based on that minutes differences

this report is to monitor a sales representative performance, what is the average time he/she follows up the lead? what is the longest and the fastest time needed for that sales rep to follow up the leads? I dont know how to apply average, max and min for minutes difference.

can I do that in Zoho CRM? or do you have better solution/approach maybe?