"MROUND" - Need Min. 0.25 Value

[jcarey]

I am utilizing "MROUND" to round to values of 0.25, 0.50, 0.75 & 1.00 - it works great, but I can't use a "0.00" value (I need min. 0.25) -- what can I do?

 

[jcarey]

This is for my timesheets.
My employer rounds to the 1/4 hour (0.00, 0.25, 0.50, 0.75, 1.00).
But I keep track in a separate file by the exact minute--from that file I copy and paste as links into the final timesheet, where I need to round to the 1/4 hour.
Sometimes I have 0.02 hours because I've responded to an email or something on a particular job and it only takes a minute.
I have to show that I worked on that job, so I need to show at least 0.25 hours (it works out in the end because the 0.23 hours just comes off of another job).
This is the most accurate way I think I can do it.
So I have to be able to show min. 0.25 for 0.02.

≤0.25 Needs to show 0.25.

Does that make sense?

 

[jcarey]

This is for my timesheets.
My employer rounds to the 1/4 hour (0.00, 0.25, 0.50, 0.75, 1.00).
But I keep track in a separate file by the exact minute--from that file I copy and paste as links into the final timesheet, where I need to round to the 1/4 hour.
Sometimes I have 0.02 hours because I've responded to an email or something on a particular job and it only takes a minute.
I have to show that I worked on that job, so I need to show at least 0.25 hours (it works out in the end because the 0.23 hours just comes off of another job).
This is the most accurate way I think I can do it.
So I have to be able to show min. 0.25 for 0.02.

≤0.25 Needs to show 0.25.

Does that make sense?

Sorry, not the above--this...
≤0.25 (down to 0.01) Needs to show 0.25.

 

[Joe4]

So, let me see if I have this right:
1. If the value you are rounding is 0, returning 0
2. If the value is greater than 0, but rounds to 0, return 0.25
3. Otherwise, round to the nearest 0.25

If that is correct, try this:

=IF(A2=0,0,MAX(MROUND(A2,0.25),0.25))

 

[jcarey]

So, let me see if I have this right:
1. If the value you are rounding is 0, returning 0
2. If the value is greater than 0, but rounds to 0, return 0.25
3. Otherwise, round to the nearest 0.25

If that is correct, try this:

=IF(A2=0,0,MAX(MROUND(A2,0.25),0.25))

Yes, that is correct (sorry if I didn't explain it well before).
Thanks.
Let me try this...

 

[jcarey]

Yes, that is correct (sorry if I didn't explain it well before).
Thanks.
Let me try this...

This seems to be working perfectly.
Thank you very much!

 

[Joe4]

You are welcome!