Adding timeStamps by unique fields query

[HughbertD]

Hi all,

 

I have a table which holds information for meetings, in the form of, startDate (timestamp), finishDate(timestamp), meetingCompany (varchar).

 

I want to:

 

Add up the total amount of time spent in meetings for each different company. But only include meetings that are longer than 2 hours long.

 

I haven't a clue how to do this, which is why I have come to you guys, I was told that this was possible in SQL but I had my doubts.

 

If anyone can help I would really appreciate it

[HughbertD]

So far I have,

 

select timediff(dateTimeFin, DateTimeStart) from calendar;

 

I'm lost as to how to distinguish between meetings over 2 hours and to add them up by each company

[aschk]

I'm assuming each entry has a company id associated with it?

 

SELECT company_id
      , SUM(TIMESTAMPDIFF(dateTimeFin, DateTimeStart)) as 'diff'
FROM calendar
WHERE TIMESTAMPDIFF(HOUR, dateTimeFin, DateTimeStart) >= 2
GROUP BY company_id