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.
<-Previous Topic Next Topic->
For more resources for Microsoft Excel: