Thread: Help with calculating time

Hello

I have an issue that i'm not familiar with and again equally not knowledgable to do...so i'm looking for the answer.


the minimal increment a time to calculate on a spreadsheet that i'm working on is .25 minutes. If a user work time is 7.16 then his time within the spreadsheet is represented as 7.25.

My question what is the calculation to make sure any number below .25 is rounded up to .25?

Any help appreciated.

-Shamunda

Originally Posted by shamunda

My question what is the calculation to make sure any number below .25 is rounded up to .25?

Are you sure that's all...what if it was 7.52:
wouldn't you want that rounded to 7.75?

Plus do you always want the next UP?
Wouldn't you want 7.52 to be 7.50...the one closest?

If I understand your question correctly, you just want to know how to round up to the quarter-minute. I assume that you're writing a computer program? I can tell you how to represent the problem mathematically in terms of functions, and then perhaps someone else can provide some efficient psuedocode.

Let represent the time worked in minutes. We want to round up to the nearest quarter-minute. Thus we're only concerned with the fractional portion of let's call it , and let's call the integer portion Let be the rounded time. Then

I imagine shamunda wants a formula that can be used in the spreadsheet. Of course, spreadsheets vary but Microsoft Excel has built in function "Floor" such that "Floor(A3, 0.25)" will reduce the number in Cell A3 to the closest multiple of .25 below the number in A3.

Originally Posted by AlephZero

If I understand your question correctly, you just want to know how to round up to the quarter-minute. I am assume that you're writing a computer program? I can tell you how to represent the problem mathematically in terms of functions, and then perhaps someone else can provide some efficient psuedocode.

Let represent the time worked in minutes. We want to round up to the nearest quarter-minute. Thus we're only concerned with the fractional portion of let's call it , and let's call the integer portion Let be the rounded time. Then

Yes That's exactly what i'm looking for!! I apologize for my late response but yes that's exactly what i'm looking for. I can write out the code for it, but i'm afraid my math skills are greatly inefficient

Sham

Yeah i'm going to need help on the pseudo code as well. I thought i would be able to work it ouot until i realized i have no idea what that formula means :P

So if someone can get me started I think i can take the rest on my own. My apologies for being a bit premature with excitment.

-Sham

Originally Posted by HallsofIvy

I imagine shamunda wants a formula that can be used in the spreadsheet. Of course, spreadsheets vary but Microsoft Excel has built in function "Floor" such that "Floor(A3, 0.25)" will reduce the number in Cell A3 to the closest multiple of .25 below the number in A3.