title: What data type should I use for a 'duration' attribute?
body: <p>I'm using phpmyadmin/MySQL to make a database.</p>
  
  <p>It's for a plane/bus/train booking system.</p>
  
  <p>I have a 'depart_time' attribute which is a time data type. In the same table I have a 'duration' attribute. Later on I will need to do multiplication on this duration attribute (depending on if it is train/bus/plane).</p>
  
  <p><strong>My question is</strong> - what would be the best data type for this duration attribute?</p>
  
  <p>I thought about using a decimal type - but then the values in it won't represent the time exactly (e.g. 1.30 won't represent 1 and a half hrs, it would need to be 1.50 - if that makes sense).
  I also thought about using the time data type for this field as well, but I wasn't sure if multiplication would be possible on that?</p>
  
  <p>I couldn't find any help after googling about multiplication on the time data type.</p>
  
  <p>Hopefully this made sense, if you need anymore information then feel free to ask in the comments!</p>
  
  <p>Thanks in advance!</p>