| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Rounding to nearest integer
I have searched many many places and still cannot find my answer. I have a
worksheet that I am calculating workers minutes allowed - I used =SUM(B322:B323) which is correct, then I have to total hours per day - I need to total using the number obtained from Min Allowed divided by 60 then calulated to the nearest half ex: 7.1, 7.2, 7.3,7.4 = 7.5 and/or 7.6, 7.7, 7.8, 7.9 = 8 I need the formula for rounding to the nearest half hour Any help is much appreciated as I'm really lost |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rounding numbers up or down | Excel Discussion (Misc queries) | |||
| Rounding to the nearest 9th | Excel Discussion (Misc queries) | |||
| Rounding numbers to the nearest thousand | Excel Discussion (Misc queries) | |||
| Rounding number to the nearest quarter | Excel Worksheet Functions | |||
| Rounding a number down to the nearest 5? | Excel Worksheet Functions | |||
Threaded Mode
