- Excel Book Excerpt
This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.
Convert Time to Decimal Hours
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.
Figure 572 Multiply times by 24 to get hours.
For more resources for Microsoft Excel: