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.
Subscribe to:
Post Comments (Atom)
-
Many people are familiar with online e-mail accounts that provide access from anywhere you have Internet access. These accounts include G...
-
This is the text version of a YouTube Live session of Go Ask Debbie: How to Delete Blank Rows in Excel. I thought I'd just do a quick ...
-
I often hear people say "I no longer see the Forward, Reply, and Reply to All buttons on my emails. How do I get this information back?...
No comments:
Post a Comment