Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel Rounding Up to Nearest Multiple
I have a list of minutes spent on billable activites. Times are billed in 15 minutes increments. For exampe 20 minutes would be rounded up to 30 minutes. When I try to use the mround feature (mround(a3,15) where a3 = 15), it rounds to the nearest 15 minute increment, or in this example down to 15 minutes. Is there an option to combine mround with roundup to accomplish this? -- jshrader ------------------------------------------------------------------------ jshrader's Profile: http://www.excelforum.com/member.php...o&userid=22890 View this thread: http://www.excelforum.com/showthread...hreadid=386502 |
#2
|
|||
|
|||
Try this: If your minutes are in A1 and are entered as whole numbers (12, 9, etc): =CEILING(A1,15) If they are entered as time (00:12, 00:09, etc): =CEILING(A1,(15/(60*24))) Does that help? Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=386502 |
#3
|
|||
|
|||
Ron: Thank you!!! This did work fine! -- jshrader ------------------------------------------------------------------------ jshrader's Profile: http://www.excelforum.com/member.php...o&userid=22890 View this thread: http://www.excelforum.com/showthread...hreadid=386502 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounding to nearest integer | Excel Worksheet Functions | |||
Exporting from Excel to multiple XML files | Excel Discussion (Misc queries) | |||
Rounding numbers to the nearest thousand | Excel Discussion (Misc queries) | |||
Multiple excel users can open the same file and edit at the same . | Excel Discussion (Misc queries) | |||
Why do my links break when I burn multiple Excel files to a CD? | Excel Worksheet Functions |