SUM & MROUND Formulas
 

Hi,
I am working on a timesheet where I have converted hours and minutes into
decimals. I then have totaled the decimals to get the total number of hours
worked. I want to round the total to the nearest 1/4 of an hour. (I.e. if
someone works 12 hours and 39 minutes (12.65 hours), they should be credited
for 12.75 hours, but if they work 12 hours and 34 minutes (12.57 hours), they
only get credit for 12.5 hours worked.) Is it possible to simultaneously sum
and round? Is it possible to simultaneously sum and MROUND to the nearest
multiple of .25? Any help is appreciated, and I realize this is like asking
someone else to do my homework for me, but I am at my wits end with that
little #NAME result I keep getting. I am using Excel 2003. Thanks.

SUM & MROUND Formulas
 

Do you mean like

=ROUND(SUM(A1:A10)*4,0)/4

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"dewey" wrote in message
...
Hi,
I am working on a timesheet where I have converted hours and minutes into
decimals. I then have totaled the decimals to get the total number of
hours
worked. I want to round the total to the nearest 1/4 of an hour. (I.e.
if
someone works 12 hours and 39 minutes (12.65 hours), they should be
credited
for 12.75 hours, but if they work 12 hours and 34 minutes (12.57 hours),
they
only get credit for 12.5 hours worked.) Is it possible to simultaneously
sum
and round? Is it possible to simultaneously sum and MROUND to the nearest
multiple of .25? Any help is appreciated, and I realize this is like
asking
someone else to do my homework for me, but I am at my wits end with that
little #NAME result I keep getting. I am using Excel 2003. Thanks.

SUM & MROUND Formulas
 

Hi

=ROUND(Value*4,0)/4


--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )



"dewey" wrote in message
...
Hi,
I am working on a timesheet where I have converted hours and minutes into
decimals. I then have totaled the decimals to get the total number of
hours
worked. I want to round the total to the nearest 1/4 of an hour. (I.e.
if
someone works 12 hours and 39 minutes (12.65 hours), they should be
credited
for 12.75 hours, but if they work 12 hours and 34 minutes (12.57 hours),
they
only get credit for 12.5 hours worked.) Is it possible to simultaneously
sum
and round? Is it possible to simultaneously sum and MROUND to the nearest
multiple of .25? Any help is appreciated, and I realize this is like
asking
someone else to do my homework for me, but I am at my wits end with that
little #NAME result I keep getting. I am using Excel 2003. Thanks.

SUM & MROUND Formulas
 

YES!!! Thanks so much.

"Bob Phillips" wrote:

Do you mean like

=ROUND(SUM(A1:A10)*4,0)/4

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"dewey" wrote in message
...
Hi,
I am working on a timesheet where I have converted hours and minutes into
decimals. I then have totaled the decimals to get the total number of
hours
worked. I want to round the total to the nearest 1/4 of an hour. (I.e.
if
someone works 12 hours and 39 minutes (12.65 hours), they should be
credited
for 12.75 hours, but if they work 12 hours and 34 minutes (12.57 hours),
they
only get credit for 12.5 hours worked.) Is it possible to simultaneously
sum
and round? Is it possible to simultaneously sum and MROUND to the nearest
multiple of .25? Any help is appreciated, and I realize this is like
asking
someone else to do my homework for me, but I am at my wits end with that
little #NAME result I keep getting. I am using Excel 2003. Thanks.