Mathmatical formula help needed

[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

 

[Biff]

Hi Kingtriton,

Use the ROUND function:

=ROUND(27.48,1) returns 27.5
=ROUND(A1,1)

Biff

 

[Jazzer]

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