title: Query to Convert Varchar HH:MM to Integer Minutes in SQL Server 2008
body: <p>I am having a table in SQL Server where there is a column name  <code>TimeSpent Datatype Varchar(25)</code>. It basically stores Time as <code>HH:MM</code> Format.
  As per the requirement now i want that it gives me actual timespent in Minutes i.e. 01:00 gives me 60, 01:30 -> 90.
  Please help me to write the query in SQL Server 2008 , so that will convert Varchar (HH:MM) into Minutes(integer).</p>