title: Difference in minutes from two time fields in MySQL
body: <p>I set up my MySQL database with the field 'time'</p>
  
  <p>It is not HH:MM in the traditional sense, it is the time an event occurred, so an event with the value of 5:45 occurred with 5 minutes 45 seconds left in a game. 12:25 occurred with 12 minutes and 25 seconds left, etc.</p>
  
  <p>I would like to be able to find out the total time elapsed, so if I have an event that occurred at 12:25 and the next event occurred at 5:45 I want to be able to get the difference, which would be equal to 6:40. Then, I would like to express this as a decimal, in this case 6.67.</p>
  
  <p>Is this possible?</p>
  
  <p>Thanks in advance.</p>