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:
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.

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

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: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=525425

daddylonglegs wrote:
I can't quite see exactly what you're trying to do but in general if yo
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 formul
in the FLOOR function thus

=FLOOR(formula,0.25
If the value is 1.25 I want that to round up to 2.0

If the value is <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: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=525425

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

Perhaps try

=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!!!!!!!!!!!!!!!

=INT(A1+0.75)

..25<=A1<1.25 will result in 1
1.25<=A1<2.25 will result in 2
2.25<=A1<3.25 will result in 3
etc.

"Darts" wrote:

daddylonglegs wrote:
I can't quite see exactly what you're trying to do but in general if yo
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 formul
in the FLOOR function thus

=FLOOR(formula,0.25
If the value is 1.25 I want that to round up to 2.0

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

Sloth wrote:
=INT(A1+0.75)

.25<=A1<1.25 will result in 1
1.25<=A1<2.25 will result in 2
2.25<=A1<3.25 will result in 3
etc.

I can't quite see exactly what you're trying to do but in general if yo
want to round down a positive value to the previous 0.25
[quoted text clipped - 8 lines]

If the value is <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?