Mathmatical formula help needed

  • Thread starter Thread starter Kingtriotn
  • Start date Start date
K

Kingtriotn

Does anyone know how to write a formula to convert time card punche
into payroll friendly numbers? I dont need to figure out how man
hours an employee has worked, that is already done. I just need t
convert the time worked to a number usable by payroll. I will b
dealing with numbers like 27.48 that need to be rounded to the neares
thenth of an hour. I have found lots of charts that show what to roun
to at what times, but I dont want to use Vlookup for this. Is there
simple formula for this?
Thanks,
Kingtrito
 
Hi,

If you could send some examples about what is the original figure and
what it should look like, this would be much easier.

To round a number to its nearest tenth, you can use

=ROUND(27.48,1) in newer excels (2k, xp and 2003 I think)

or

=INT(27.48*10+0.5)/10 which should work in all excel version.

- Asser
 
Back
Top