Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Using MS Excel 2003 Professional Edition...
I've created a time and attendance worksheet where people can enter their hours in increments of .25 for 15-minute intervals. I can't format the cells to sum numbers without rounding it to the next highest number. This causes problems such as: 2.50 + 7.25 = 9.80 (when it should read 9.75) I know that I could add decimal points to the format (7.250) to correct the problem, but this makes the sheet messy and cluttered, and my boss doesn't like it. He wants it to read 8, not 8.000 when it's just a single number. Can anyone assist? Thanks for your time! :-) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can Excel evaluate a series of numbers | Excel Discussion (Misc queries) | |||
How do I sort letters before numbers in Excel? | Excel Discussion (Misc queries) | |||
stop excel from rounding a result | Excel Worksheet Functions | |||
How do I stop Excel from changing simple numbers to their 1/100th. | Excel Discussion (Misc queries) |