Check out this web site. Scroll down to the bottom:
http://www.cpearson.com/excel/datearith.htm

tj

"cpme" wrote:

I am trying to build a timecard database in Excel. How do I go about
rounding the time to the nearest 1/4 hour? Is this even possible? I tried
using the MROUND function but you have to specify a specific number to round
to and since I'm dealing with timecards, the numbers are always different.
Any ideas?