Convert Time to Hours in Excel

Standard

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).

=HOUR(CELL) + MINUTE(CELL) / 60 + SECOND(CELL) / 3600

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:

WordPress.com Logo

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

Google photo

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

Twitter picture

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

Facebook photo

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

Connecting to %s