title: Excel: Converting a duration (hours, minutes, seconds) to increments of 6 minutes
body: <p>I have a spreadsheet column with durations of hours, minutes, and seconds.  For example, 0:01:00 is 1 minute.  1:06:28 is 1 hour, 6 minutes, and 28 seconds.</p>
  
  <p>I'm trying to convert this data into increments of 10% of an hour (6 minutes).  So, 0:00:01 (a second) would be converted to 0.1.  0:06:00 (6 minutes) would also be 0.1.  1:12:01 (1 hour, 12 minutes and 1 second) would be 1.3.</p>
  
  <p>Any ideas on how to handle this in Excel (or Google Sheets)?  Thanks very much.</p>