On Friday, January 15, 2010 at 7:31:19 PM UTC-6, TeriS wrote:
I, too, am setting up a timesheet. It is a very simple timesheet but I can't
seem to figure out this (what should be) simple function. My question is:

Time In Time Out Total Minutes worked (These are usually 45 min
classes)
9:00 AM 9:45 AM 0:45
9:30 AM 10:15 AM 0:45
9:00 AM 9:35 AM 0:35
Total time worked 1 hr. 20 min. This is the time I need rounded
to the nearest 1/4 hour. I can do it in the same cell or a cell directly
below this one. Whichever is easiest (I am NOT Excel proficient).

TIA,
Teri

You can put this below/to the right (or in any empty cell really) of the value you want rounded to the nearest 15 minute mark and replace the "A1" cell reference in the formula with a reference to the cell you are wanting to round. =mround(A1, 1/96)