Excel: Convert Time to Decimal Hours

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.


Problem: I bill my clients hourly. How can I convert Excel times to decimal hours so that I can do my billing?

Strategy: Multiply the Excel by 24 to come up with a decimal number of hours. You can them multiply the hours by the hourly rate to calculate the billing.

  1. Multiply times by 24 to get hours.