| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding to the nearest quarter hour no longer working
I have a time sheet that I've been using for several months, and today it's
been acting funky. I have the sheet calculating the hours for the day in, say, A1, and I have it rounding those hours to the nearest quarter hour in A2 with the formula =MROUND(A1,0.25). It has always worked in the past, but today, my rounding in A2 is coming up as #NAME. I checked my previous documents, and if I try and edit those in any way, it changes my rounded results to #NAME. I have already checked and made sure that the Analysis Toolpack is loaded to no avail. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rounding to the nearest quarter | Excel Worksheet Functions | |||
| Rounding a sum to the quarter hour. | Excel Worksheet Functions | |||
| Rounding up to nearest quarter, (:25, :50, :75, :00) | Excel Discussion (Misc queries) | |||
| How do I round time to the nearest quarter of an hour | New Users to Excel | |||
| Need to round the time to the nearest quarter hour. Help | Excel Discussion (Misc queries) | |||
Threaded Mode
