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
Bookmarks