Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding 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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding Time?
stoch05 wrote:
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding Time?
Use the mRound function that comes with the Analysis ToolPak in your Excel
Addins. If you don't have it activated, got to ToolsAddins... 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, -- Gary Brown If this post was helpful, please click the ''Yes'' button next to ''Was this Post Helpfull to you?''. "stoch05" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
time sheet to calculate 2 different columns | Excel Worksheet Functions | |||
Excel Time Sheet - Rounding To Quarter Hours | Excel Worksheet Functions | |||
Rounding Time? | Charts and Charting in Excel | |||
rounding time question | Excel Worksheet Functions | |||
Rounding time in excel (2003) | Excel Discussion (Misc queries) |