Time Converter

Can any body write a query program to convert time in this format hr:min:sec to minutes only and any seconds greater than zero should be approximated to one seconds. for example: 2:13:03 = 134minutes

send your reply in form of query to akeemogun@yahoo.com