This article will convert current local time in (UTC/GMT) - World Time Zone
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 converting time to decimals, 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 to convert Minute value you can use formula called "CONVERT"
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.