Convert Time to Hours in Excel


I’ve found myself having to convert time in Excel stored as hours, minutes, seconds (e.g. 3:42:09) into hours in decimal format (e.g. 3.70) for invoicing my time and every month I end up googling this.

The method I use is a formula in Excel using the Excel Time functions (HOUR, MINUTE, and SECOND).


Replace CELL with the appropriate cell in your Excel workbook (e.g. A2).


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s