Overtime calculation

[Guest]

I have an overtime calculation, however I need it to round to the nearest
quarter...Currently it reads: =sum(N16/2). What needs to be added or
changed and added.

 

[Bob Phillips]

I assume you mean quarter dollar not hour?

=ROUND(sum(N16/2)*4,0)/4

 

[Guest]

Acutally I mean quarter hour...don't ask...

I assume you mean quarter dollar not hour?

=ROUND(sum(N16/2)*4,0)/4

 

[Bob Phillips]

Okay, then try

=ROUND(sum(N16/2)*24*4,0)/4/24

You might want to look at

http://www.xldynamic.com/source/xld.Rounding.html
Rounding In Excel

--

HTH

RP

Acutally I mean quarter hour...don't ask...

 

[Guest]

Bob you are a gem, maybe you can assist me in taking this one step
further...I want it to round up or down, dependant on which quarter has a
closer proximity.

I assume you mean quarter dollar not hour?

=ROUND(sum(N16/2)*4,0)/4

 

[Guest]

Bob,
So sorry, my brain is running on empty today...thank you for all of your
assistance!

Bob you are a gem, maybe you can assist me in taking this one step
further...I want it to round up or down, dependant on which quarter has a
closer proximity.