Hi,

I am currently working on a project whereby I enter fractions of hours,
and they appear in cells as decimals. So, for example, if I want to
enter 10 minutes, I enter 10/60 and the value in the cell comes up as
0.1666666.... (I round it to 2 decimal places, though!)

Okay, so that's the easy part. The next part of the problem comes if I
wish to "round" (or whatever the correct term is) the number to the
nearest quarter hour. So, for example, if I've entered 10 minutes (or
0.1666666....) I need to round it UP to 15 minutes, or 0.25. If I've
entered 20 minutes (or 0.333333....), I need to round it DOWN to 15
minutes, or 0.25.

(Sorry if I'm being ponderous in my spelling of things out; I'm sure
most of you probably get the point of what I'm trying to say!)

Now, I know about the CEILING and FLOOR functions, but what I'm looking
for here is something that really combines the two, or selects from
these two the most appropriate function. So, in other words, it's
something similar to ROUND, in that it "rounds" either up or down, but
works in the same way as CEILING or FLOOR. Does that make sense? Is it
possible for Excel to do that?

Gus Venables


--
gusvenables
------------------------------------------------------------------------
gusvenables's Profile: http://www.excelforum.com/member.php...o&userid=28408
View this thread: http://www.excelforum.com/showthread...hreadid=480009