On Fri, 15 Jan 2010 17:31:19 -0800, 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


If you want to tally only 15 minute increments, you can (should) only
use 15 minute increments.

The "9:35" entry is invalid in such a policy. If you FORCE all entries
to be at 15 minute increments only, you no longer need to round anything
off. You can do that by way of "data validation".