Time diff in Amazon Athena / Presto (seconds and minutes )

date_diff

date_diff('second', min(creation_time),max(ending_time))

unix_timestam() function converts date to seconds passed from 1970-01-01

SELECT 
  (unix_timestamp('2017-03-20 10:55:00') - unix_timestamp('2017-03-20 10:56:00'))

OK
-60

Divide by 60 to get minutes

Edit: The solution above works in Hive. Presto does not have unix_timestamp as @nclark mentioned in the comment. There is to_unixtime function in Presto, it returns DOUBLE, so you need to cast it to bigint. The same logic in Presto:

CAST(to_unixtime(max(ending_time)) AS BIGINT) - CAST(to_unixtime(min(creation_time)) AS BIGINT)