Time is held as a fraction of a day, so to round to an hour, we multiply by
24, to a half-hour by 48 (24*2), to a quarter-hour by 96 (24*4). This number
is rounded, and then divided by the original multiplier to get it back to
the same scale as starting at.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"neopolitan" wrote
in message ...
Okay Bob, I'll confess, I was trying a different approach (much more
complicated) and I don't understand where the "96" in your formula
comes from. Can you enlighten me?
--
neopolitan
------------------------------------------------------------------------
neopolitan's Profile:
http://www.excelforum.com/member.php...nfo&userid=611
View this thread: http://www.excelforum.com/showthread...hreadid=486320