 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / October 2006Rounding Time?
I need to keep track of compensatory time earned and accumulated. Compensatory time is paid out at time and one-half. When calculating 7.75 hours worked at time and one-half, you get 11.625 hours. I need to round this up to 11.75 hours. Can anyone help? > I need to keep track of compensatory time earned and accumulated. > Compensatory time is paid out at time and one-half. When calculating 7.75 > hours worked at time and one-half, you get 11.625 hours. I need to round > this up to 11.75 hours. Can anyone help? What is the general rule: round up __or__ down to the closest 1/4 hour; or always round __up__ to the closest 1/4 hour; or something else altogether? For example, what should 11.6 round to? What should 11.76 round to? To always round up to the closest 1/4 hour, here is one way: =0.25 * roundup(A1/0.25, 0) Try that with 11.6 and 11.76, among others, and be sure you get the desired results. Use the mRound function that comes with the Analysis ToolPak in your Excel Addins. If you don't have it activated, got to Tools>Addins... Click both the Analysis ToolPak and Analysis ToolPak-VBA Select OK =MROUND(7.75*1.5,0.25) where... .25 is the increments you want to round to. Examples: MROUND(7.75*1.5,0.25) or MROUND(11.625,0.25) evaluates to 11.75 MROUND(7.70*1.5,0.25) or MROUND(11.550,0.25) evaluates to 11.50 HTH,  SignatureGary Brown gary_brown@ge_NOSPAM.com If this post was helpful, please click the ''Yes'' button next to ''Was this Post Helpfull to you?''. > I need to keep track of compensatory time earned and accumulated. > Compensatory time is paid out at time and one-half. When calculating 7.75 > hours worked at time and one-half, you get 11.625 hours. I need to round > this up to 11.75 hours. Can anyone help? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.