Friday, July 16, 2010

Excel: Convert Times into Decimals

Many companies use Excel to track timesheets. Employees may not know that the Human Resources Department needs to track time within quarter hours. Some may even want to track in smaller increments.

Here is a quick formula to use so that employees do not have to convert the hours and minutes themselves.

Type this formula (where A1 is the cell containing the time)

=HOUR(A1) (MINUTE(A1)/60)

This will convert 12:35 (time) into 12.58 (decimal).

Then, you might even setup the timesheet to subtract the starting and ending times to calculate the number of hours worked, using the decimal fields.
HINT: Hide these formulas from user forms. You only need to have employees type in the times and not worry about the decimals.

1 comment:

How to Delete Blank Rows in Excel