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