Use the HOUR and MINUTE formulas to extract the hour and minute numbers from the time.
For example ..
You have time as “3:30 PM” and you want to convert it in Decimal, so that it will display 3o minute as a Half of hour, or display the result as “15:50″
To convert time to decimal values:
you can use below formula
or if you want to convert Minute value you can use formula called “CONVERT”
=HOUR(A3) + CONVERT(MINUTE(A3),”mn”,”hr”)