• Excel Book Excerpt

Excel Convert Time to Decimal Hours

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: