Rounding hh:mm to nearest 15, 30, 45 minutes
Total time worked...1 hr. 20 min
I think your total time should be 2:05. Rounded to the nearest quarter hour
would be 2:00.
Try this...
=ROUND(SUM(C2:C4)*96,0)/96
--
Biff
Microsoft Excel MVP
"TeriS" wrote in message
...
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
|