Obviously something happened to your ATP add-in. However to round to the
nearest quarter without using ATP is not hard



with the time in C1

=ROUND(C1/(1/96),0)*(1/96)


however it seems you are rounding decimal values to the nearest quarter not
times (Excel times in the format of hh:mm etc)

either


=ROUND(C1/0.25,0)*0.25


or


=ROUND(C1*4,0)/4


--
Regards,

Peo Sjoblom




"dramajuana" wrote in message
...
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?