Excel 2013 Tutorial - How to Convert Decimal Hours, Minutes to a Standard Time
When you import data from external databases the time there sometime is recorded in decimal hours.
For example one hour and 30 minutes (1:30) instead of that you see 1.5.
In order to do the conversion from decimal hours to standard hours you need to divide the decimal hours by 24.