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.

For more resources for Microsoft Excel