To convert time to decimal values:
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″
you can use below formula..
or if you want excel to convert Minute value for you.. you can used Excel’s another formula called “CONVERT”
=HOUR(A3) + CONVERT(MINUTE(A3),”mn”,”hr”)