converting time more than 24 hours to a decimal

[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!

 

[Biff]

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

 

[BenjieLop]

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!

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