B
bstevens
In cell B6, I have a time value in hours and minutes. I have a formula
that rounds it DOWN to fourths and expresses the hours in 00, .25, .50
and .75. For example, if the time in B6 is 8:26, it produces 8.25
hours. 8:43 produces 8.5 hours. In that manner, it always rounds it
DOWN to the nearest quarter. The formula I'm using is:
=INT(G6*24)+INT(MOD(G6*24,1)/0.25)*0.25
Can somebody please tell me how to modify this formula to round it UP
instead of DOWN? So, for example, 8:01 through 8:15 would produce 8.25
hours. 8:16 through 8:30 would produce 8.50 hours. 8:31 through 8:45
would produce 8.75, and 8:76 through 9:00 would produce 9.0 hours.
I've played with this thing until I'm blue in the face and can't make
it work.
This would save a lot of people a lot of time and errors in hand-
calculating their time sheets at work.
Please reply only to the group.
Thanks a heap,
Ron M.
that rounds it DOWN to fourths and expresses the hours in 00, .25, .50
and .75. For example, if the time in B6 is 8:26, it produces 8.25
hours. 8:43 produces 8.5 hours. In that manner, it always rounds it
DOWN to the nearest quarter. The formula I'm using is:
=INT(G6*24)+INT(MOD(G6*24,1)/0.25)*0.25
Can somebody please tell me how to modify this formula to round it UP
instead of DOWN? So, for example, 8:01 through 8:15 would produce 8.25
hours. 8:16 through 8:30 would produce 8.50 hours. 8:31 through 8:45
would produce 8.75, and 8:76 through 9:00 would produce 9.0 hours.
I've played with this thing until I'm blue in the face and can't make
it work.
This would save a lot of people a lot of time and errors in hand-
calculating their time sheets at work.
Please reply only to the group.
Thanks a heap,
Ron M.