Formulas for excel

giggles321 | 17:10 Thu 20th Nov 2008 | Technology

1 Answers

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

1394?

downloading films

Answers

Only 1 answer

Best Answer

No best answer has yet been selected by giggles321. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.

ChuckFickens

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 :)

Only 1 answer

Do you know the answer?