Technology

Formulas for excel

I am trying to make up a timesheet in excel but need the formulas to round the hours up or down. Any ideas??

giggles321 Thurs 20/11/08 17:10

<< Previous

Next >>

Subscribe to question

Post an Answer

ChuckFickens
Thurs 20/11/08
18:47

excel has three commands

ROUND
ROUNDUP
ROUNDDOWN

so to get cell b1 to display and round the contents of cell a1 would be

=ROUND(a1,1)

Would display contents of cell a1 rounded to one decimal place

or to round a sum would be

=ROUND(77/3,2)

would display 77/3 rounded to 2 decimal places

The number after the comma is the number of decimal places you want to round to, 0 being no decimal places.

ROUNDUP and ROUNDDOWN are used in the same way but will round in the direction stated.

Google excel round command for more help, though not sure how it will work with time, I hate dealing with time in excel :)

Post an Answer

Submit the above question and answers

add to del.icio.us	add to digg	add to furl
add to reddit	add to Technorati	add to Blinklist
add to StumbleUpon	add to squidoo	add to ma.gnolia
add to Cocomment	add to Netscape	add to Fark