title: Converting xx:xx:xx time formation to minutues in Excel
body: <p>I'm currently working on a dataset that has a duration field in time format, I'm trying to convert this into just minutues however haven't been succesful in doing so.</p>
  <p>Is there a formula to convert these formats into mintues or seconds.</p>
  <p>The format is HH:MM:SS some examples of data displayed and required output below.</p>
  <p>Example</p>
  <p>00:01:00 = 1</p>
  <p>00:01:30 = 1.5</p>
  <p>00:02:00 = 2</p>