converting time more than 24 hours to a decimal

  • Thread starter Thread starter prinna.boudreau
  • Start date Start date
P

prinna.boudreau

Trying to convert time cards with multiple times listed
for a week to a decimal for the payroll company I use.

After 5 days of work my employee has 43 hours and 50
minutes worked. Need an easy way to convert this to 43.83
for my payroll company without doing the math for each
employee.

Thanks for any help!
 
Hi!

All you need to do is to multiply by 24. If you have 100
employees you can do it in one operation:

In an empty cell enter 24.
Copy this cell.
Select all the total cells for all employees.
Then do Paste Special>Mutiply.

Biff
 
Trying to convert time cards with multiple times listed
for a week to a decimal for the payroll company I use.

After 5 days of work my employee has 43 hours and 50
minutes worked. Need an easy way to convert this to 43.83
for my payroll company without doing the math for each
employee.

Thanks for any help!
Click to expand...

Assuming your total hours column is time formatted, e.g., 43:50 for th
total hours worked, then enter this formula ,in say, Cell B1:

=A1*24

where A1 contains your total hours worked.

NOTE: Cell B1 should be formatted as a Number (2 decimal places).

Hope this will help you
 
Back
Top