Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
Problem with named formula's | Excel Worksheet Functions | |||
Formulas | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |