software

If someone was to work 7:00am to 8:15am my result is 1.25 hrs. I am trying to
round up which I can do easily however if the Total time is Less than 1.25 I
would like for it to round down to 1hr. How do I put that into a formula.Here is how my formula looks
IN
OUT
In out Hour Minute value
Hour minute value total Hrs Rounded
7:00:00am 8:15:00am 7 - 7.0 8
15 8.25 1.25 2.0

now if the total hr is 1.24 I need that to have a rounded value of 1.0

I hope I explained myself clear enout

Thanks

Darts wrote:
gt;If someone was to work 7:00am to 8:15am my result is 1.25 hrs. I am trying to
gt;round up which I can do easily however if the Total time is Less than 1.25 I
gt;would like for it to round down to 1hr. How do I put that into a formula.
gt;
gt;if the total hr is 1.24 I need that to have a rounded value of 1.0
gt;
gt;I hope I explained myself clear enout
gt;
gt;Thanks


I can't quite see exactly what you're trying to do but in general if you
want to round down a positive value to the previous 0.25

=FLOOR(A1,0.25)

if your value is calculated by a formula then just enclose your formula
in the FLOOR function thus

=FLOOR(formula,0.25)--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=525425daddylonglegs wrote:
gt;I can't quite see exactly what you're trying to do but in general if yo
gt;want to round down a positive value to the previous 0.25
gt;
gt;=FLOOR(A1,0.25)
gt;
gt;if your value is calculated by a formula then just enclose your formul
gt;in the FLOOR function thus
gt;
gt;=FLOOR(formula,0.25
If the value is 1.25 I want that to round up to 2.0

If the value is lt;1.25 I want that to round down to 1.0


So does that apply to other numbers, what happens to 3.3 or 5.4?

Perhaps try

=ROUND(A1 0.25,0)--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=525425=INT(A1 0.75)

..25lt;=A1lt;1.25 will result in 1
1.25lt;=A1lt;2.25 will result in 2
2.25lt;=A1lt;3.25 will result in 3
etc.

quot;Dartsquot; wrote:

gt; daddylonglegs wrote:
gt; gt;I can't quite see exactly what you're trying to do but in general if yo
gt; gt;want to round down a positive value to the previous 0.25
gt; gt;
gt; gt;=FLOOR(A1,0.25)
gt; gt;
gt; gt;if your value is calculated by a formula then just enclose your formul
gt; gt;in the FLOOR function thus
gt; gt;
gt; gt;=FLOOR(formula,0.25
gt; If the value is 1.25 I want that to round up to 2.0
gt;
gt; If the value is lt;1.25 I want that to round down to 1.0
gt;

daddylonglegs wrote:
gt;So does that apply to other numbers, what happens to 3.3 or 5.4?
gt;
gt;Perhaps try
gt;
gt;=ROUND(A1 0.25,0

3.3 would round to 4 since .3 equates to 15 minutes or greater in time
5.4 would round to 6 sinc .4 equates to 15 minutes or greater

I am not sure but .23 is equivalent to 14 minutes.

I am not very good at explaining things. If the total hr adds up to 1.24
then I would like that number rounded to 1

If it is 1.25 rounded to 2.

I hope this helps so you can help me!!!! I'm pretty new at this and all of
you sound like einsteins!!!!!!!!!!!!!!!


Sounds like

=ROUND(A1 0.25,0) would work for you then, or perhaps Sloth's (shorter)
suggestion

=INT(A1 0.75)

I believe these would do the same thing--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=525425Sloth wrote:
gt;=INT(A1 0.75)
gt;
gt;.25lt;=A1lt;1.25 will result in 1
gt;1.25lt;=A1lt;2.25 will result in 2
gt;2.25lt;=A1lt;3.25 will result in 3
gt;etc.
gt;
gt;gt; gt;I can't quite see exactly what you're trying to do but in general if yo
gt;gt; gt;want to round down a positive value to the previous 0.25
gt;[quoted text clipped - 8 lines]
gt;gt;
gt;gt; If the value is lt;1.25 I want that to round down to 1.0

Oh My God that worked!!!!!

Thank You Thank You Thank You
What does INT mean ? How did you figure this out?

INT takes the integer portion of a number. So INT(1.23456)=1, and
INT(22.99999)=22.

Your problem was similar to a rounding trick I learned in a programming
class a long time ago. The problem in that class was to use the INT function
to round a number; the solution was INT(A1 0.5). You are actually wanted a
skewed rounding, so I figured the solution had to be similar.

That's kind of how I figured it out. Sorry if I confused you, I'm not real
good at explaining my thought processes.

quot;Dartsquot; wrote:

gt; Sloth wrote:
gt; gt;=INT(A1 0.75)
gt; gt;
gt; gt;.25lt;=A1lt;1.25 will result in 1
gt; gt;1.25lt;=A1lt;2.25 will result in 2
gt; gt;2.25lt;=A1lt;3.25 will result in 3
gt; gt;etc.
gt; gt;
gt; gt;gt; gt;I can't quite see exactly what you're trying to do but in general if yo
gt; gt;gt; gt;want to round down a positive value to the previous 0.25
gt; gt;[quoted text clipped - 8 lines]
gt; gt;gt;
gt; gt;gt; If the value is lt;1.25 I want that to round down to 1.0
gt;
gt; Oh My God that worked!!!!!
gt;
gt; Thank You Thank You Thank You
gt; What does INT mean ? How did you figure this out?
gt;